Open FishtownBuildBot opened 4 days ago
We should:
snapshot_meta_column_names
which can be used to customize the names of the snapshot meta-fields created by dbt internally to satisfy my org’s naming conventionsNote:
Here's an example of the new config:
{{
config(
target_database='analytics',
target_schema='snapshots',
unique_key='id',
strategy='timestamp',
updated_at='updated_at',
snapshot_meta_column_names={
dbt_valid_from: start_date,
dbt_valid_to: end_date,
dbt_scd_id: scd_id,
dbt_updated_at: updated_date
}
)
}}
You can also set this in your dbt_project.yml like:
snapshots:
my_project:
+snapshot_meta_column_names={
dbt_valid_from: start_date,
dbt_valid_to: end_date,
dbt_scd_id: scd_id,
dbt_updated_at: updated_date
}
Hi @nataliefiann I see this is "in review", but I don't see a PR linked. Lemme know when you're ready for me to take a look!
At a minimum, update body to include a link to the page on docs.getdbt.com requiring updates and what part(s) of the page you would like to see updated. Originating from this issue: https://github.com/dbt-labs/dbt-core/issues/10185