With the release of the official ClickHouse Kubernetes operator, the new standard for production self-hosted ClickHouse clusters is to make use of the replicated database engine. This produces similar functionality to ClickHouse Cloud, in that it does not work with CREATE TABLE ... AS SELECT. SQLMesh already has a workaround for this with cloud mode. This mode can only be enabled by having "clickhouse.cloud" in the host name. I have added a CNAME to my dns to have my clickhouse host be resolved by clickhouse.cloud.my.domain.net to get around this. In the long run it would be good to have this property be a setting in ClickHouse connection config. Read more on the new paradigm here: https://clickhouse.com/docs/clickhouse-operator/overview
With the release of the official ClickHouse Kubernetes operator, the new standard for production self-hosted ClickHouse clusters is to make use of the replicated database engine. This produces similar functionality to ClickHouse Cloud, in that it does not work with CREATE TABLE ... AS SELECT. SQLMesh already has a workaround for this with cloud mode. This mode can only be enabled by having "clickhouse.cloud" in the host name. I have added a CNAME to my dns to have my clickhouse host be resolved by clickhouse.cloud.my.domain.net to get around this. In the long run it would be good to have this property be a setting in ClickHouse connection config. Read more on the new paradigm here: https://clickhouse.com/docs/clickhouse-operator/overview