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 w...
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