topic Re: How to check a specific table for it's VACUUM retention period in Administration & Architecture

How to check a specific table for it's VACUUM retention period

WWoman — Tue, 28 Jan 2025 17:14:51 GMT

I'm looking for a way to query for the VACUUM retention period for a specific table. This does not show up with DESSCRIBE DETAIL <table_name>;

Re: How to check a specific table for it's VACUUM retention period

filipniziol — Tue, 28 Jan 2025 19:31:55 GMT

Hi @WWoman ,

the default retention period is 7 days and as per documentation it is regulated by 'delta.deletedFileRetentionDuration' table property:

If there is no delta.deletedFileRetentionDuration table property it means it uses the default, so 7 days.
If you set the delta.deletedFileRetentionDuration like this:

ALTER TABLE dev.bronze.source_table SET TBLPROPERTIES ('delta.deletedFileRetentionDuration' = '30 days');

you will be able to check the property by running SHOW TBLPROPERTIES:

SHOW TBLPROPERTIES dev.bronze.source_table;

The result:

However, one can always run the VACUUM overwriting the defaults, so if you have any process that explicitly states the number of retained hours, you won't be able to check this at table properties level:

Re: How to check a specific table for it's VACUUM retention period

WWoman — Tue, 28 Jan 2025 19:36:53 GMT

Thank you!

Re: How to check a specific table for it's VACUUM retention period

filipniziol — Tue, 28 Jan 2025 19:38:54 GMT

No problem, glad it was helpful!