Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Learn Microsoft Fabric

14.3k members • Free

1 contribution to Learn Microsoft Fabric
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.
1-1 of 1
Mike Li
1
5points to level up
@mike-li-8072
Senior Data Engineer

Active 376d ago
Joined May 5, 2024
Powered by