Forum Discussion
Querying Table History in SQL Analytics Endpoint
Has anyone attempted/managed to query table history (e.g. version) in SQL Analytics Endpoint? I am currently able to do so via notebooks by submitting spark-sql but for convenience sake, I think it would make more sense to be able to get table history info right within SQL Anlytics Endpoint instead of having to switch apps when trying to work with different versions of a table.
3 Replies
HI scca,
Did you mean to trace the query activities? If that is the case, you can use 'query activities' and 'DMVs' to check all of the history queries and detail activities.
Monitor your running and completed queries using Query activity - Microsoft Fabric | Microsoft Learn
Monitor connections, sessions, and requests using DMVs - Microsoft Fabric | Microsoft Learn
Regards,
Xiaoxin Sheng
Thanks for your response, Xiaoxin. However, I was referring to getting the history of a table, e.g. table version, which is what we would get if we ran "DESCRIBE HISTORY {table name}" for Delta tables.
Hi scca,
In fact, if you want to run these query in sql analytics endpoint, you need to input the actual path of the delta table.
I tried with lots of type of delta table path but all of these queries return the syntax error to recognize the delta table path string.(it seems only find the database table in the sql analytics endpoint instead of the lakehouse delta table)Regards,
Xiaoxin Sheng
