CI pipelines are failing because of different reasons

[koletzilla]

There are different bugs that are preventing the CI from passing, even on the main branch. This is making development somewhat painful. We should fix at least the most impactful ones to regain focus on real bugs and issues.

Pending tasks:

• [x] The latest version of ClickHouse makes ON CLUSTER operations take too much time (up to 90 seconds), and it's blocking all jobs. https://github.com/ClickHouse/dbt-clickhouse/pull/502
• [x] tests/integration/adapter/basic/test_snapshot_check_cols.py::TestSnapshotCheckCols::test_snapshot_check_cols has started failing in all PRs.
  • Being fixed here https://github.com/ClickHouse/dbt-clickhouse/pull/509 and here https://github.com/ClickHouse/dbt-clickhouse/pull/511
• [x] There are some small linting errors, probably found by newer versions of the linting libraries. https://github.com/ClickHouse/dbt-clickhouse/pull/502
• [ ] Tests running against ClickHouse Cloud are still not working correctly.
  • [x] https://github.com/ClickHouse/dbt-clickhouse/pull/509#pullrequestreview-3205701736
  • [ ] Pending to fix remaining flaky tests
  • [ ] Test takes a long time and cannot be parallelized https://github.com/ClickHouse/dbt-clickhouse/issues/499).
  • [ ] Support safe concurrent dbt runs https://github.com/ClickHouse/dbt-clickhouse/issues/420
• [x] isort is missing some import orders in CI. https://github.com/ClickHouse/dbt-clickhouse/pull/505
• [x] Some tests are not compatible with ClickHouse 23.8 https://github.com/ClickHouse/dbt-clickhouse/issues/503