Azure Synapse Serverless SQL Pool
What you'll learn: How to query data stored in Azure Data Lake Storage using serverless SQL without spinning up dedicated infrastructure.
What Is Synapse Serverless SQL Pool?
Azure Synapse Serverless SQL Pool is a query service that lets you run T-SQL queries directly against data files in Azure Data Lake Storage Gen2 (and Blob Storage) without provisioning any compute resources upfront. Think of it as Athena's Azure counterpart—you pay only for the data processed by your queries, not for idle servers.
Unlike traditional databases or dedicated SQL pools that require you to load data first, serverless SQL pool reads files in place. You point it at Parquet, CSV, or JSON files in your storage account, define external tables or use OPENROWSET, and query immediately.
Core Capabilities
External tables let you create table-like abstractions over file collections:
CREATE EXTERNAL TABLE Sales (
OrderID INT,
Amount DECIMAL(10,2)
)
WITH (LOCATION = 'sales/*.parquet', DATA_SOURCE = MyDataLake);
Ad-hoc querying with OPENROWSET reads files directly without schema definition:
SELECT *
FROM OPENROWSET(
BULK 'https://mystorageaccount.dfs.core.windows.net/data/sales.parquet',
FORMAT = 'PARQUET'
) AS SalesData;
You can query across partitions, join multiple file sets, and apply standard T-SQL transformations—all without managing clusters or worrying about capacity planning.
Use Cases
Perfect for exploratory data analysis, one-off reports, and data lake querying where you want flexibility without committed infrastructure. Since billing is per-TB scanned, optimize with file formats (Parquet over CSV), partitioning, and column pruning.
Key Takeaway: Azure Synapse Serverless SQL Pool enables T-SQL queries on Data Lake Storage files with zero infrastructure management, charging only for data processed—ideal for flexible, on-demand analytics workloads.