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

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

DESCRIBE HISTORY in Fabric Warehouse (table versions, time travel)

Please add an equivalent to Spark's DESCRIBE HISTORY in Fabric Warehouse which will enable us to see a list of Warehouse table versions that can be queried for time travel purposes.

Status: New
Comments
frithjof_v
Community Champion

Some use cases: *verify that ETL over time has committed new table versions as expected *verify that transactions are working as expected and intended *verify that there are no other ETL processes, that I'm unaware of, writing to the table *troubleshooting in case of unexpected data / blank data in Power BI / Direct Lake (I've had to do this when writing Dataflow Gen2 -> Lakehouse, or Copy Activity -> Lakehouse, a few times because they committed a single write as two separate transactions to delta lake) *understanding when and how table maintenance gets applied to the table *see what table versions exist, so that I can use these timestamps for time travel queries, in case I want to check data issues or compare data changes due to changes in the ETL code *if possible, see how many rows got inserted / deleted / updated in each transaction