question

sakuraime avatar image
0 Votes"
sakuraime asked PRADEEPCHEEKATLA-MSFT answered

Azure synapase Delta lake external table

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format

May I know if it support delta table time travel ..

like

select * from table timestamp as of.....

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered

Hello @sakuraime,

Thanks for the question and using MS Q&A platfrom.

Azure Synapse Analytics is compatible with Linux Foundation Delta Lake. Delta Lake is an open-source storage layer that brings ACID (atomicity, consistency, isolation, and durability) transactions to Apache Spark and big data workloads.

Key features of Delta Lake:

138432-image.png

Limitation:

Serverless SQL pools do not support time travel queries. Use Apache Spark pools in Azure Synapse Analytics to read historical data.

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators


image.png (123.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.