Fabric Spark SQL Query on Delta Version

Jun '24 • Technical

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.

2 comments

skool.com/microsoft-fabric

Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.

Leaderboard (30-day)

+33

+24

+19

+15

+13