Repository navigation
Fix ClickHouse cloud tests #458
Description
Describe the bug
Fix the broken GitHub workflow for dbt Cloud integration tests and add a nightly scheduled run to catch regressions.
{{ message }}
Fix the broken GitHub workflow for dbt Cloud integration tests and add a nightly scheduled run to catch regressions.
Activity
koletzilla commentedon Oct 16, 2025
I have been working on it here and right now we have a set of tests failing. They're all related to
GRANToperations liketest_incremental_grants.py. Looks like the grant is not synced at the moment of the creation with all replicas, so if the GRANT check is done to one replica that has not received it, the test will fail.Same thing happens with the
CREATE USERright at the beginning.I have tried a few things:
select_sequential_consistency = 1worked to wait for data in tables but don't seem to affect here.ON CLUSTERoperation sodistributed_ddl_task_timeoutdon't apply.SYSTEM SYNC DATABASE REPLICA defaultas it seems it only works for replicated databases and in CH clouddefaultisShared.I have asked for more ways to solve this, but right now the only way to solve it is to:
SELECT count() from system.clusters WHERE database = 'default'select count() from clusterAllReplicas('default', system.users)where ...(orFROM clusterAllReplicas('default', system.grants)') is the same as the number of replicas we found before.koletzilla commentedon Jan 15, 2026
I have not seen these
granttests failing any more.Taking into account that + the fact that we have already included testing against CH Cloud in each PR with #512, I'm going to close this ticket now. If small things happen again, we can create independent issues to work on it.