dbt-clickhouse icon indicating copy to clipboard operation
dbt-clickhouse copied to clipboard

snapshot invalidate_hard_deletes feature

Open dstsimokha opened this issue 8 months ago • 1 comments

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 default__snapshot_staging_table macro can be modified in two places by changing {{ strategy.unique_key }} to toNullable({{ strategy.unique_key }}) - in snapshotted_data and deletes_source_data CTEs

dstsimokha avatar Jun 09 '24 16:06 dstsimokha