Skip to main content

Querying Delta Lake files using T-SQL in Azure Synapse Analytics is generally available

Published date: October 29, 2021

Serverless SQL pools in Azure Synapse Analytics enable you to read data stored in Delta Lake format.

The Delta Lake is a big data format that is commonly used by data engineers who are working with Apache Spark pools in Azure Synapse Analytics and Azure Databricks. The Delta Lake format enables Spark data engineers to update big data sets with guaranteed ACID consistency.

The serverless SQL pools in Azure Synapse Analytics enable data analysts to read and analyze data, create Power BI reports, and populate Azure Analysis Service models directly from the files stored in the Delta Lake format. Serverless SQL pools bind the reporting and analytic tools with the data stored in the Delta Lake format. This enables data analysts and engineers to easily share data between both Apache Spark pools and a serverless SQL pool in Azure Synapse, Azure Databricks, and create real-time reports on top of Delta Lake files, without the need to copy and transform data.

Find more information in the article How to query Delta Lake files using serverless SQL pools.

  • Features