Comment
Valued Contributor II

@rakhidarshi Good article. Thanks for the same.

Few things -

1. If schema changes are made using Schema evolution merges, then it cannot be tracked in the history table. > is there a workaround to track columns being added via schema evolution?

2. Data Retention Compliance (File Cleanliness) > you mean to check if no older versions of the delta table in compliance with the fileretentionduration property are present? Appreciate if you could give the SQL query.