dbt-clickhouse

dbt-clickhouse copied to clipboard

### Describe the bug For some reason, the tests' schemas are not being deleted when running with ClickHouse cloud.. ### Expected behavior The schema is supposed to be cleaned properly....

BentsiLeviav

Support chdb

2

**Is your feature request related to a problem? Please describe.** This issue does not fix a problem. **Describe the solution you'd like** I would like to use dbt to run...

fithisux

Table and Column Comments set up misbehaviour

5

### Describe the bug Testing [v1.7.7 Community PRs](https://github.com/ClickHouse/dbt-clickhouse/releases/tag/v1.7.7) exacly: allows to add a comment in table's or view's metadata by @dstsimokha in https://github.com/ClickHouse/dbt-clickhouse/pull/228 We've found, that generated ALTER TABLE SQL...

GavrG

Storing credentials in the profile

2

**Is your feature request related to a problem? Please describe.** I'm trying to store some sensitive variables like storage account credentials in the dbt profile, and then use them in...

ms32035

snapshot invalidate_hard_deletes feature

1

**Is your feature request related to a problem? Please describe.** invalidate_hard_deletes=True for snapshots not working with CH because of its default non-nullable column **Describe the solution you'd like** dbt general...

dstsimokha

**Is your feature request related to a problem? Please describe.** 'temporary' tables such as the 'new data' table (e.g. `my_table__dbt_new_data_` ), can clutter the main databases causing confusion to users....

the4thamigo-uk

Two materialized views writing to the same table

3

CH MVs are insert triggers on the source table. It is possible to setup two or more MVs that write their records to a single table. from what I can...

the4thamigo-uk

Apply order_by and/or primary_key on snapshots

1

**Is your feature request related to a problem? Please describe.** Currently snapshots are created without a primary key and sort key -- the snapshot config does not respect `order_by` or...

barberscott

Incremental model not add on cluster expression in `create table *__dbt_new_data_*`

1

Subsequence run incremental model with on cluster seems not work currently. (try to use `delete+insert` and `default`) First run work fine when incremental model create Replicated* table (and table materialization...

oleg-savko

### Describe the bug ### Steps to reproduce 1. Use the following model ```sql {{ config(order_by='old_customer_id') }} SELECT a .number as old_customer_id, b.number FROM system.numbers a LEFT JOIN ( SELECT...

dvic