Forum Discussion
Solved
Fabric Warehouse - table versions
Hello, Is there an easy t-sql way to view list of versions of delta table in MS-Fabric Warehouse database? Like we have in spark with "describe history ..." ? I know what there's a way to get it a...
Hello J_Fad,
yup, so far missing this functionality in T-SQL experience. However you can do it using spark sql in the notebook.
Attach your warehouse to the notebook and query it using 4 part path
%%sqlDESCRIBE HISTORY <workspace>.<warehouse>.<schema>.<table>SELECT * FROM <schema>.<table> OPTION (FOR TIMESTAMP AS OF 'desired timestamp')
https://learn.microsoft.com/en-us/fabric/data-warehouse/time-travel
Not that trivial, but seem we will get some updates in the future.
Hello J_Fad
DESCRIBE HISTORY is a Spark / Delta Lake construct, implemented in Spark SQL, and as such, it cannot be used in T‑SQL in Microsoft Fabric.
T‑SQL in Fabric does not expose Delta transaction logs or table‑level history metadata in a DESCRIBE HISTORY‑equivalent command. This is a known and documented limitation.
Fabric T‑SQL supports time travel querying using TIMESTAMP AS OF. This is query‑level time travel, not table audit history.