Querying Delta Lake files using T-SQL in Azure Synapse Analytics is generally available
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 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](https://aka.ms/query-delta-lake-synapse-analytics-serverless-sql-pool).
* Features
What else is happening at Microsoft Azure?
Read update
Services
Share
Generally Available: Storage account default maximum request rate limit increase to 40,000 requests per second
December 12th, 2024
Services
Share
Read update
Services
Share
Generally Available: Regional Disaster Recovery by Azure Backup for AKS
November 22nd, 2024
Services
Share
Generally Available: Enhancements on Azure Container Storage for performance, scalability, and operational insights
November 19th, 2024
Services
Share