v.18.12Improvement

Support for ATTACH TABLE ... ON CLUSTER Queries

Support for ATTACH TABLE ... ON CLUSTER queries. #3025
Support for ATTACH TABLE ... ON CLUSTER queries allowing distributed management of table attachments across clusters.

Why it matters

This feature enables users to attach existing tables simultaneously on all nodes within a specified cluster, simplifying cluster-wide table management and ensuring consistency across distributed ClickHouse setups.

How to use it

Use the ATTACH TABLE ... ON CLUSTER <cluster_name> syntax to attach tables on all nodes of the specified cluster. For example:

ATTACH TABLE my_table ON CLUSTER my_cluster;