ClickHouse/dbt-clickhouse

View on GitHub

The Clickhouse plugin for dbt (data build tool)

Stars: 362
Forks: 177
Open beginner issues: 0
Indexed issues: 117
Avg merge: 2d 19h
Merged PRs (30d): 5

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 10, 2026
Latest indexed: Sep 15, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue

Open All

117 open issues indexed

Union all issues Open

enhancement

ClickHouse/dbt-clickhouse#75 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Incremental update errors with `NUMBER_OF_COLUMNS_DOESNT_MATCH` with tuple unique_key Open

bug

ClickHouse/dbt-clickhouse#84 · 1 comment · 8 reactions · 0 assignees · Indexed Sep 15, 2026
Add support for macro get_tables_by_pattern_sql Open

enhancement good first issue

ClickHouse/dbt-clickhouse#108 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Python models support Open

enhancement

ClickHouse/dbt-clickhouse#113 · 4 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Is it possible to use parameterized views ? Open

ClickHouse/dbt-clickhouse#131 · 10 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Strategy for breaking down the cost of joins Open

enhancement

ClickHouse/dbt-clickhouse#142 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Retries should retry on known retriable database errors in addition to connection errors Open

enhancement

ClickHouse/dbt-clickhouse#165 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support for a JDBC source Open

enhancement

ClickHouse/dbt-clickhouse#204 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Not ADD ON CLUSTER when create __dbt_backup Open

bug

ClickHouse/dbt-clickhouse#205 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Question: How optimal is snapshot for large tables? Open

question

ClickHouse/dbt-clickhouse#218 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Generic test materializing not using ON CLUSTER Open

bug

ClickHouse/dbt-clickhouse#225 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 15, 2026
dbt test command recreates the whole database Open

enhancement

ClickHouse/dbt-clickhouse#235 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Lightweight Deletes are now GA Open

documentation enhancement

ClickHouse/dbt-clickhouse#242 · 1 comment · 2 reactions · 0 assignees · Indexed Sep 15, 2026
AWS Access key is not being fetched from env variables Open

bug good first issue

ClickHouse/dbt-clickhouse#243 · 8 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Cannot add new columns to incremental models Open

bug good first issue

ClickHouse/dbt-clickhouse#258 · 3 comments · 3 reactions · 0 assignees · Indexed Sep 15, 2026
Move 'temporary' tables to a working database Open

enhancement

ClickHouse/dbt-clickhouse#281 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
ALTER UPDATE/ALTER DELETE statement with subquery may be nondeterministic Open

bug

ClickHouse/dbt-clickhouse#282 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
snapshot invalidate_hard_deletes feature Open

enhancement

ClickHouse/dbt-clickhouse#291 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Table and Column Comments set up misbehaviour Open

bug

ClickHouse/dbt-clickhouse#295 · 8 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Storing credentials in the profile Open

enhancement

ClickHouse/dbt-clickhouse#296 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support chdb Open

ClickHouse/dbt-clickhouse#297 · 2 comments · 5 reactions · 0 assignees · Indexed Sep 15, 2026
Tests schema are not being cleaned up Open

bug

ClickHouse/dbt-clickhouse#298 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Field name annotation encoding error Open

bug

ClickHouse/dbt-clickhouse#308 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Database tab is empty in generated docs Open

bug

ClickHouse/dbt-clickhouse#311 · 9 comments · 9 reactions · 0 assignees · Indexed Sep 15, 2026
ttl not added to local table in distributed_incremental materialization Open

bug

ClickHouse/dbt-clickhouse#321 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`distributed_table` materialization doesn't guranatee idempotency (in respect of table structure) Open

bug documentation

ClickHouse/dbt-clickhouse#333 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Authenticate via SSH key instead of password Open

ClickHouse/dbt-clickhouse#339 · 8 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Running DBT on MacOS with dbt-clickhouse does not support renameat2() Open

bug good first issue

ClickHouse/dbt-clickhouse#340 · 7 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Cannot change between view and distributed table on cluster Open

bug

ClickHouse/dbt-clickhouse#345 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support update_field on dictionary materializations Open

enhancement good first issue

ClickHouse/dbt-clickhouse#352 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Insert query that is OOM'ing in Clickhouse is returning OK to dbt Open

bug

ClickHouse/dbt-clickhouse#360 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Unnecessary Setting added Open

bug

ClickHouse/dbt-clickhouse#372 · 17 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
[Bug] <clickhouse replicated error & freeze> Open

bug

ClickHouse/dbt-clickhouse#388 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
insert_overwrite strategy can miss data on node failover Open

bug

ClickHouse/dbt-clickhouse#418 · 2 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Support safe concurrent dbt runs Open

bug

ClickHouse/dbt-clickhouse#420 · 6 comments · 5 reactions · 0 assignees · Indexed Sep 15, 2026
Missing ON CLUSTER clause when using insert_overwrite with Replicated table engine Open

bug documentation

ClickHouse/dbt-clickhouse#426 · 4 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Seeds are dropped before recreated Open

enhancement

ClickHouse/dbt-clickhouse#433 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
{{ this }} references not replaced by backup table name during materialized view full refresh Open

bug

ClickHouse/dbt-clickhouse#434 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
append_new_columns doesn't allow you to add new columns to a model Open

bug

ClickHouse/dbt-clickhouse#435 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature parity for distributed and non-distributed materializations Open

enhancement

ClickHouse/dbt-clickhouse#439 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Contract validation failed if data_type in lower case Open

bug

ClickHouse/dbt-clickhouse#445 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
adding the ability to authorize via a custom API path Open

enhancement

ClickHouse/dbt-clickhouse#451 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add ca_cert credential for http connection Open

enhancement

ClickHouse/dbt-clickhouse#459 · 2 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Generic tests ought to support `final` keyword Open

enhancement

ClickHouse/dbt-clickhouse#462 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
use EMPTY statement in refreshable MVs Open

enhancement

ClickHouse/dbt-clickhouse#465 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Option to alter table attached to Materialized View on schema changes Open

enhancement

ClickHouse/dbt-clickhouse#474 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Unable to create new snapshot Open

bug

ClickHouse/dbt-clickhouse#475 · 8 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Inefficient Schema change check Open

bug

ClickHouse/dbt-clickhouse#480 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
dbt snapshot - check strategy - stopped working properly Open

bug

ClickHouse/dbt-clickhouse#481 · 16 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
dbt retry + microbatch fails to retry only failed batches Open

bug

ClickHouse/dbt-clickhouse#482 · 0 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026

ClickHouse/dbt-clickhouse

Get new issues in your inbox