dbt-clickhouse

dbt-clickhouse copied to clipboard

## Summary Current distributed incremental runs will drop local production tables when the distributed tables are missing. This can cause irrevesable data loss. The proposed fix will only drop and...

canbekley

Insert query that is OOM'ing in Clickhouse is returning OK to dbt

1

### Describe the bug I have an insert query that is consisently out of memory-ing. In the Clickhouse logs I can see an exception 241 being thrown on the query....

barberscott

Starting from v.24.2 ClickHouse have **sql security** and **definer** logic (for view) https://clickhouse.com/docs/en/sql-reference/statements/create/view#sql_security It would be greate, to have this options for **View** materialization at dbt-clickhouse

alexsubota

Hi, it would be great if dbt-ch supported [skip indexes](https://clickhouse.com/docs/en/optimize/skipping-indexes), much like it does projections. Eg ``` {{ config( engine='MergeTree()', order_by='id, materialized='table', indexes=[{ 'name': 'minmax_received_ts', 'column': 'received_ts', 'type': 'minmax', 'granularity':...

stephen-up

`distributed_table` materialization doesn't guranatee idempotency (in respect of table structure)

1

### Describe the bug and step to reproduce: In dbt, default behavior of `table` materialization is to drop and recreate the table. If I run the same dbt model twice,...

rightx2

**Is your feature request related to a problem? Please describe.** Dictionaries that are backed by large clickhouse tables/queries typically are reloaded from the entire dataset. This may be inefficient if...

the4thamigo-uk

max_bytes_before_external_group_by not working with DBT

5

### Describe the bug I am running a dbt model with _max_bytes_before_external_group_by_ settings. Still, I am getting Memory Error. If the run the same query on ClickHouse cloud it works...

rupesh-plateiq

### Describe the bug We want to use dbt on a Clickhouse cluster with two nodes. As far as I can tell, you cannot switch from a view materialization to...

krisnej

Running DBT on MacOS with dbt-clickhouse does not support renameat2()

7

### Describe the bug When running : `dbt run --target=clickhouse-dev --select=dbt_mart` on MacOS Sonoma 14.6.1 (MacBook Pro (13-inch, M1, 2020)) ``` 08:27:45 Running with dbt=1.7.17 08:27:46 Registered adapter: clickhouse=1.7.7 08:27:46...

LPauzies

### Describe the bug It seems to be extra quotation in split_part macro. If you run `{{ dbt_utils.get_url_parameter("url","field_name") }}` it results in following code: ``` nullif( splitByChar(''&'', splitByChar(''field_name='', url)[2] )[1]...

3fonov