Skip to main content

Query Delta Lake files using T-SQL in Azure Synapse Analytics (public preview)

Published date: May 27, 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 enable data engineers to update big data sets with guaranteed ACID consistency.

A serverless SQL pool in Azure Synapse 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. A serverless SQL pool resource binds 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.

  • Azure Synapse Analytics
  • Features

Related Products