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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
5 months ago

Thankyou, Lozovskyi and deborshi_nag for your responses.

Hi J_Fad,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by Lozovskyi and deborshi_nag to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.