CI pipelines are failing because of different reasons #501
Description
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:
- The latest version of ClickHouse makes ON CLUSTER operations take too much time (up to 90 seconds), and it's blocking all jobs. Fix CI running in main: make lint and test_matrix work again #502
- tests/integration/adapter/basic/test_snapshot_check_cols.py::TestSnapshotCheckCols::test_snapshot_check_cols has started failing in all PRs.
- There are some small linting errors, probably found by newer versions of the linting libraries. Fix CI running in main: make lint and test_matrix work again #502
- Tests running against ClickHouse Cloud are still not working correctly.
- Fix cloud tests and problems with snapshots not using a consistent now() #509 (review)
- Pending to fix remaining flaky tests
- Test takes a long time and cannot be parallelized Investigate slow execution time of dbt tests on ClickHouse Cloud #499).
- Support safe concurrent dbt runs Support safe concurrent dbt runs #420
- isort is missing some import orders in CI. Fix isort not working in Github Actions #505
- Some tests are not compatible with ClickHouse 23.8 Some tests are failing when the test is executed with ClickHouse 23.8 #503