Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to Solution.
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!
Clone and Time Travel in Fabric Data Warehouse
https://www.youtube.com/watch?v=ZVgizgPQRS8&list=PLNbt9tnNIlQ5TB-itSbSdYd55-2F1iuMK&index=6
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!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
9 | |
6 | |
5 | |
2 | |
2 |
User | Count |
---|---|
14 | |
11 | |
7 | |
5 | |
4 |