The official documentation for Serverless SQL Pools is available from the following links:
Overview
Quick Start
- Overview: What is Azure Synapse Analytics?
- Quickstarts: Creating a Synapse workspace (Azure Portal)
- Workspace: Quickstart: Create an Azure synapse workspace with Azure PowerShell
- Quickstarts: Analyze data with serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Quickstart: Use serverless SQL pool
Architecture & Development Practices
- Workspace: Azure Synapse Analytics shared database
- Synapse SQL: Serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Azure Synapse SQL architecture
- Synapse SQL: Transact-SQL features supported in Azure Synapse SQL
- Synapse SQL: Design decisions and coding techniques for Synapse SQL features in Azure Synapse Analytics
- Synapse SQL: Use T-SQL loops with Synapse SQL in Azure Synapse Analytics
- Synapse SQL: Stored procedures using Synapse SQL in Azure Synapse Analytics
- Synapse SQL: User-defined schemas within Synapse SQL
Tutorials
- Synapse SQL: Tutorial: Explore and Analyze data lakes with serverless SQL pool
- Synapse SQL: Tutorial: Use serverless SQL pool with Power BI Desktop & create a report
Reading Data From Storage
- Synapse SQL: Query storage files with serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query CSV files
- Synapse SQL: Query Parquet files using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query JSON files using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query nested types in Parquet and JSON files by using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query folders and multiple files
- Synapse SQL: Use file metadata in serverless SQL pool queries
- Synapse SQL: Create and use views using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Create and use external tables using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: How to use OPENROWSET using serverless SQL pool in Azure Synapse Analytics
Writing Data To Storage
Connectivity
- Synapse SQL: Connect to Synapse SQL
- Synapse SQL: Connect to Synapse SQL with Azure Data Studio
- Synapse SQL: Connect to Synapse SQL with SQL Server Management Studio (SSMS)
- Synapse SQL: Connect to serverless SQL pool with Power BI Professional
- Synapse SQL: Quickstart: Use Python to query a database
Best Practices
Administration
- Workspace: Quickstart: Create an Azure Synapse workspace with the Azure Portal
- Workspace: Quickstart: Create an Azure synapse workspace with Azure PowerShell
- Synapse SQL: Cost management for serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Use Synapse Studio to monitor your SQL requests
- Synapse SQL: Statistics in serverless SQL pool
- Tech Community: Always use UTF-8 collations to read UTF-8 text in serverless SQL pool
- Reference: System views supported in Synapse SQL
- Workspace: Synapse Studio SQL scripts in Azure Synapse Analytics
- Workspace: Use Azure Monitor with your Azure Synapse Analytics workspace
- Workspace: How to set up access control for your Synapse workspace
- Workspace: Troubleshoot reading UTF-8 text from CSV or Parquet files using serverless SQL pool in Azure Synapse Analytics
Troubleshooting
- Workspace: Troubleshoot connectivity between Azure Synapse Analytics Synapse Studio and storage
- Resources: Self-help for Serverless SQL pool
- Overview: Microsoft Q&A Question Page
- Overview: Stack Overflow