The problem I’m having in Big Query:
{{config(
materialized=‘incremental’
,schema= abc
,incremental_strategy = ‘merge’
,unique_key=[‘EMP_ID’]
,merge_exclude_columns = [‘Audit_ID’, ‘Crt_Timestamp’]}}
I need to convert this config Code compatible to Big Query ,I see in dbt document “merge_exclude_columns = [‘Audit_ID’, ‘Crt_Timestamp’]” wont work with Big Query, could someone please help me with fixing this code and help with compatible code in Big query.
Kindly let me know , if we use the Merge_exclude_columns in config part pointing to Big query ,Will it accepts or any change i need to do in config section ,Kindly suggest ,Thanks