Automatic Storage tier/class assignment

[sajnor]

In the "ducklake_data_file," information is stored indicating which files are no longer relevant (i.e., end_snapshot is not null). This information can be used to automatically set the storage tier (e.g., ADLS) or storage class (e.g., BigQuery, AWS).

By default, cloud storage uses the "Hot" tier. However, once a snapshot is no longer relevant, a parameter in the ATTACH operation could specify whether DuckLake should transition the storage tier/class to "Cool" or "Cold" for all irrelevant snapshots.

Additionally, when the VACUUM operation is performed, a parameter in the ATTACH operation could determine whether files should be moved to an "Archive" storage tier instead of being deleted.

Yes, this could be implemented in Python, but it would be ideal if managing storage tiers or classes could be made simpler.