Maintained with ☕️ by
IcePanel logo

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

Share

Services

[Serverless SQL pools](https://docs.microsoft.com/azure/synapse-analytics/sql/on-demand-workspace-overview) in [Azure Synapse Analytics](https://docs.microsoft.com/azure/synapse-analytics/) enable you to read data stored in [Delta Lake](https://delta.io/) format. The [Delta Lake](https://delta.io/) 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](https://delta.io/) 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 analyse 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](https://aka.ms/query-delta-lake-synapse-analytics-serverless-sql-pool). * Azure Synapse Analytics * Features * [ Azure Synapse Analytics](https://azure.microsoft.com/en-gb/products/synapse-analytics/)