topic Re: how to get version history of a warehouse item in Data Engineering

how to get version history of a warehouse item

Jeanxyz — Tue, 28 Oct 2025 16:50:05 GMT

I'm reading MS documents, it shows Fabric warehouse supports time travel via T-SQL:

SELECT * FROM [dbo].[dimension_customer] AS DC OPTION (FOR TIMESTAMP AS OF '2024-03-13T19:39:35.28');

However, it doesn't mention how to get a version history of the warehouse table. In Lakehouse, I can get version history via the code below. But it doesn't work in warehouse, is there an equivalent t-sql command for warehouse tables?

%%sql

describe history dp700_LH2.orders_in

Re: how to get version history of a warehouse item

tayloramy — Wed, 29 Oct 2025 03:18:46 GMT

Hi @Jeanxyz,

The describe history command is a Spark SQL command, not a T SQL command.

The SQL endpoint for a warehouse only supports T SQL, not Spark (Spark is primairly used in notebooks which connect much better to lakehouses)

Is the TSQL snippet you added from the documentation not working in the warehouse SQL endpoint?

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: how to get version history of a warehouse item

Jeanxyz — Wed, 29 Oct 2025 08:33:10 GMT

The T-sql snippet works, but I'm really interested in getting the full version history of a warehouse table, not a specific version.

It looks T-sql only allows me to get the current version. But the command is strange, it doesn't specify the version id refers to which warehouse table. Does that mean the whole warehouse shares one version id?

SELECT CURRENT_TIMESTAMP

Re: how to get version history of a warehouse item

tayloramy — Thu, 30 Oct 2025 02:14:40 GMT

Hi @Jeanxyz,

So you're wanting to see all history for a table? This isn't possible directly with TSQL.

You will need to use OneLake Explorer to get at the delta logs, and then parse all the delta logs for the table to get this type of information I think.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: how to get version history of a warehouse item

v-tejrama — Fri, 31 Oct 2025 07:32:02 GMT

Hi @Jeanxyz ,

Thank you @tayloramy for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding.

Re: how to get version history of a warehouse item

frithjof_v — Sun, 22 Mar 2026 10:30:44 GMT

I've made an Idea for this: https://community.fabric.microsoft.com/t5/Fabric-Ideas/DESCRIBE-HISTORY-in-Fabric-Warehouse-table-versions-time-travel/idi-p/5137019