v.25.9Improvement

You can use query parameters after

Official CH changelog text
You can use query parameters after TO when creating a materialized view, for example: CREATE MATERIALIZED VIEW mv TO {to_table:Identifier} AS SELECT * FROM src_table. #84899 (Diskein).
Added support for using query parameters in the TO clause when creating a materialized view.

Why it matters

This feature allows users to dynamically specify the target table for a materialized view using query parameters, improving flexibility and reusability of view definitions.

How to use it

When creating a materialized view, include query parameters after the TO keyword to specify the destination table dynamically, for example:

CREATE MATERIALIZED VIEW mv TO {to_table:Identifier} AS SELECT * FROM src_table

Related resources

PreviousNext