ClickHouse / ClickHouse/dbt-clickhouse

Generic test materializing not using ON CLUSTER

Open
#225 1 comment 1 reaction 0 assignees View on GitHub
bug
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.