Describe the feature
When building a model, the "OPTIMIZE" query is executed automatically after each run. I want same feature for snapshots.
Describe alternatives you've considered
Using posthooks.
Additional context
Ideally I want to change the config of the snapshots to adjust the liquid clustering columns even for existing tables.
I also considering some kind of default (dbt_scd_id, dbt_valid_to and config.id)
Who will this benefit?
Increased performance for work with snapshots.
Are you interested in contributing this feature?
No.
Describe the feature
When building a model, the "OPTIMIZE" query is executed automatically after each run. I want same feature for snapshots.
Describe alternatives you've considered
Using posthooks.
Additional context
Ideally I want to change the config of the snapshots to adjust the liquid clustering columns even for existing tables.
I also considering some kind of default (dbt_scd_id, dbt_valid_to and config.id)
Who will this benefit?
Increased performance for work with snapshots.
Are you interested in contributing this feature?
No.