Feature Request: Table setting final to force any queries on specific table to use FINAL

[rorylshanks]

Use case

We have several tables where we rely on the ReplacingMergeTree function to deduplicate data, however not all of our tables rely on this. To guarantee deduplicated data, we have set the final setting for the accessing user, however this then applies FINAL to all tables. Ideally we would be able to specify final on a per-table setting level, which would then impact how the table is queried.

Describe the solution you'd like

To be able to create a table with
CREATE TABLE .. SETTINGS final = 1;
And then all queries on that table be executed with FINAL

Describe alternatives you've considered

Use a short min_age_to_force_merge_seconds timeout to force merges, however this then has a short duplicate period

Additional context

Add any other context or screenshots about the feature request here.

[SaltTan]

Related

• New merge tree setting to apply final by default #39463
• Unexpected exception when using final modifier with non MergeTree table #63960