Synapse SQL Serverless

Azure Synapse's serverless SQL pool offers a scalable solution for querying data directly within data lakes without requiring data movement or dedicated infrastructure. As a pay-per-query service, it enables users to analyze large datasets efficiently while only incurring costs based on the amount of data processed.

Built with T-SQL compatibility, serverless SQL pools integrate with numerous business intelligence tools and allow for on-the-fly data exploration across formats such as Parquet, Delta, and CSV.

Through schema inference and enhancements to the OPENROWSET functionality, users can seamlessly query semi-structured data, manage database objects, and integrate with security frameworks such as Microsoft Entra to support secure, multi-role access management.