Run Cloud tests against SMT

Open mshustov opened this issue 1 year ago • 1 comments

https://clickhouse.com/docs/en/cloud/reference/shared-merge-tree is the new default table engine on ClickHouse Cloud. We must ensure first-class support for SMT in DBT. Some changes to ClickHouse settings are required (tldr: use select_sequential_consistency instead of insert_quorum) See https://clickhouse.com/docs/en/cloud/reference/shared-merge-tree#settings

Credentials are available via env vars

INTEGRATIONS_TEAM_TESTS_CLOUD_HOST_SMT
INTEGRATIONS_TEAM_TESTS_CLOUD_PASSWORD_SMT

Mar 01 '24 15:03 mshustov

I created a branch with an additional GitHub job for testing against the SMT instance.

There are still a few tests failures, due to a bug, will update here once it is being solved.

Apr 25 '24 12:04 BentsiLeviav