Forum Discussion

J_Fad's avatar
J_Fad
Frequent Visitor
5 months ago
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...
data engineering
  • Lozovskyi's avatar
    Lozovskyi
    5 months ago

    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

    %%sql
    DESCRIBE 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.

Lozovskyi's avatar
Lozovskyi
Kudo Collector
5 months ago

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

%%sql
DESCRIBE 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.