Fix Errata : lastModified on Delta table properties is last "metadata" modification not last Update to the table (add rows)
Opened this issue · 0 comments
newfront commented
Under:
Calculate Table Freshness: abs(current_time()-{table.lastModified}): To answer the universal question of - "How Fresh Is It?".
-
I was using the
table.lastModified
timestamp. While this works on a new table, you quickly come to realize that unless there are "modifications" to the structure of the table, or table properties, then the modification timestamp is not useful to calculate the freshness of a table. -
instead you can use the
dt.history()
to gather the lastoperation
thatadded
or otherwise "effectively" modified the table.