Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
germo
Advocate IV
Advocate IV

Delta lake time travel in Fabric SQL endpoints?

Delta lake (and therefore OneLake) supports time travel to access specific versions of a table. But how to use this feature via TSQL using the SQL endpoints of Fabric Warehouse or Fabric Lakehouse?

spark sql would support this, but can't be used on top of the SQL endpoints.

Temporal tables are not yet supported in Fabric warehouse.

1 ACCEPTED SOLUTION
KevinConanMSFT
Microsoft Employee
Microsoft Employee

Greetings!

 

Time Travel using T-SQL and SQL Endpoint (or the Data Warehouse) is not supported at this time.  It is something that we are looking into, so please stay tuned!

View solution in original post

3 REPLIES 3
DuncanJack
Frequent Visitor

KevinConanMSFT
Microsoft Employee
Microsoft Employee

Greetings!

 

Time Travel using T-SQL and SQL Endpoint (or the Data Warehouse) is not supported at this time.  It is something that we are looking into, so please stay tuned!

HimanshuS-msft
Community Support
Community Support

Hello @germo 
Thanks for using the Fabric community.
As I undesrtand the ask right now is But how to use this feature via TSQL using the SQL endpoints of Fabric Warehouse or Fabric Lakehouse" . Let me know if thats not correct. 

I am pretty confident that this is a not supported in the current preview version . I am reaching out to the internal tem to get more info on this . Also I will request  you to add the ask here https://ideas.fabric.microsoft.com/ .

Thanks
HImanshu

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.