ClickHouse / ClickHouse/dbt-clickhouse
Generic test materializing not using ON CLUSTER
- Dominant language
- Python
- Stars
- 362
- Forks
- 176
- Avg merge
- 2d 10h
- Merged PRs (30d)
- 8
Description
### Describe the bug
Generic tests with `store_failures = true` materializing **not** using ON CLUSTER clause and provided in profiles.yml value.
Each run its actually first of all **dropping table with on cluster clause**, but right after recreating it without the clause.
### Expected behaviour
Generic tests with `store_failures = true` materializing using ON CLUSTER clause and provided in profiles.yml value
### Configuration
#### Environment
* dbt version: 1.7.3
* dbt-clickhouse version: 1.7.0
* clickhouse-driver version (if using native): 0.2.6
* clickhouse-connect version (if using http): 0.6.22
* Python version: 3.11.6
* Operating system: macos 14.2
Contributor guide
Research direction
No source file or test is named. Reproduce the generic test with store_failures = true using the reported dbt-clickhouse and ClickHouse configuration, then trace the materialization's drop and recreate statements. Done means the recreated failure table uses the ON CLUSTER value from profiles.yml, matching the drop behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- clickhouse, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100