'How to query latest version of Delta Lake table in Azure Synapse?

How can we use Azure Synapse serverless SQL pool to query the latest version of Delta Lake table ??

Below link specifies it can be done under Delta Lake, but unable to find any examples:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand#delta-lake

"You can use serverless SQL pool to query the latest version of Delta Lake"

Thanks!

azure-synapsedelta-lake


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Data Factory/Synapse: How to merge many files?

Synapse spark job fails as input folder does not exist

Synapse external table "Unauthorized"

Error on source dataset with REST Connector in Azure Synapse pipeline

Error assigning Synapse role using Terraform

TypeError: AutoMLConfig() takes no arguments in Azure Synapse

Azure Synapse insert result of exec into a table

M2M Client Credential Flow between NetSuite and Synapse

Azure Synapse IDENTITY COLUMN; Wrong Id values based on seed

Azure Syanpse Analytics

Could SSMS shows actual execution plan in Azure Synapse?

What do these different properties in SQL Server's (Azure Synapse's) Estimated Execution Plan mean?

Where to check who run pipeline in Azure Synapse

Could not create lake database from synapse notebooks

PySpark read data into Dataframe, transform in sql, then save to dataframe