ClickHouse / ClickHouse/dbt-clickhouse

Seeds are dropped before recreated

Open
#433 2 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Python
Stars
362
Forks
177
Avg merge
2d 10h
Merged PRs (30d)
8

Description

**Is your feature request related to a problem? Please describe.**
Because seeds are dropped and then recreated, we get errors in the short period of downtime when seeds are used in materialized views. Also, if the recreation of the seed fails for some reason, the downtime lasts until seed is recreated.

**Describe the solution you'd like**
Use exchange instead of drop and create.

Contributor guide

Open the contributing guide

Research direction

The issue names no file or test. Start by locating the seed drop/create lifecycle in the dbt-clickhouse adapter and review how ClickHouse exchange applies to seeds; done means materialized views avoid the drop window and a failed replacement does not leave the prior seed unavailable, with coverage for those cases.

Written by the indexing model from the issue text.

Assessment

Tech stack
clickhouse, python
Domain
databases
Issue type
Feature
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.