fix(clickhouse): support multi-gateway projects with catalog-aware engines #3768

Job	Run time
changes	6s
test-dbt-versions (1.9)	1m 44s
test-dbt-versions (1.6)	2m 45s
test-dbt-versions (1.8)	2m 3s
test-dbt-versions (1.4)	1m 29s
test-dbt-versions (1.7)	3m 7s
test-dbt-versions (1.5)	1m 39s
test-dbt-versions (1.10)	1m 46s
test-dbt-versions (1.3)	2m 49s
test-vscode-e2e	0s
test-vscode	0s
cicd-tests-windows	11m 24s
doc-tests	39s
migration-test	1m 33s
style-and-cicd-tests (3.10)	22m 58s
style-and-cicd-tests (3.9)	22m 56s
engine-tests-docker (spark)	5m 39s
engine-tests-docker (mysql)	2m 2s
engine-tests-docker (clickhouse)	2m 42s
engine-tests-docker (postgres)	2m 12s
engine-tests-docker (starrocks)	2m 44s
engine-tests-docker (trino)	8m 5s
style-and-cicd-tests (3.11)	21m 1s
engine-tests-docker (duckdb)	2m 45s
style-and-cicd-tests (3.12)	24m 31s
engine-tests-docker (risingwave)	2m 40s
engine-tests-docker (mssql)	2m 4s
style-and-cicd-tests (3.13)	21m 1s
ui-style	0s
ui-test	-1s
engine-tests-cloud	-1s
	2h 54m 22s

Provide feedback