Fabric Spark SQL Query on Delta Version
Dear Members, I am trying to get max version of a delta table using the following spark query: %%sql DESCRIBE HISTORY my_delta_table select max(version)-1 as PreviousVersion from ( DESCRIBE HISTORY my_delta_table) but the select one returned syntax error. Anyone can help? Thanks a lot.