Override DBT macro only in specific cases
I’m working on a project where I need to override the global macro default__snapshot_staging_table. I’ve successfully created this macro in my local workspace, and it’s functioning as expected. However, I want to maintain the default behavior of the macro under certain conditions.
Is it possible to remove columns from a dbt snapshot?
Regarding removing columns from a snapshot, dbt’s docs have this to say:
DBT Core- Snapshot: Parsing Error at path []: Snapshots must be configured with a ‘strategy’, ‘unique_key’, and ‘target_schema’
In dbt-core, I have created a folder under snapshots called salesforce. All my snapshot sqls are in this folder. Now I have a few common configs that I have added in dbt_project.yml given below: