Open dataders opened 5 months ago
@dataders is this something the adapters team is considering working on? Otherwise I may pick it up as it would be useful for us.
@dataders is this something the adapters team is considering working on? Otherwise I may pick it up as it would be useful for us.
it's not on the roadmap yet, any contribution would be much appreciated!
I'd also be curious to know if you've got a use case.
My understanding of the use case is that we have a downstream project that uses DT, and we have an upstream model that we have added change tracking via DDL, but if it gets full refreshed it loses the config and the downstream DT breaks.
Have you considered a post hook?
{{ config(
post_hook="alter table {{ this }} set change_tracking = true", )
}}
For my use case it's not very helpful, since I need it mainly for RAW tables created by Matillion or Fivetran, and we don't give the dbt user permission to alter raw tables. Once I have a staging layer, DT Snowflake will set change tracking for us if downstream DTs need it.
Is this your first time submitting a feature request?
Describe the feature
Context
User request (internal Slack thread):
This is not currently possible
Reference
Snowflake SQL Reference:
CREATE TABLE
Additional Info
Describe alternatives you've considered
CHANGE_TRACKING=TRUE
the new default so we need not make it explicitWho will this benefit?
Any user who relies on
change_tracking
, Dynamic Tables (dependencies of Dynamic Tables must havechange_tracking=true
), and streaming scenarios in SnowflakeAre you interested in contributing this feature?
No response
Anything else?
No response