List of columns for hashdiff with include/exclude parameters

[bschlottfeldt]

Discussed in https://github.com/ScalefreeCOM/datavault4dbt/discussions/108

^{Originally posted by marcinsiewiera August 2, 2023} Hi All,

Is there a way to define columns for change hash in stage macro by specifying columns to be excluded rather than listing all columns 1 by 1? Instead of using

hd_lineitem_n_s:
    is_hashdiff: true
    columns:
        - col1
        - col2
        - col3
        - ....
        - col50
        - ...

exclude business key

    columns:
      - include: '*' 
        exclude:
          - businessKey
          - hashKey
          - changeHash
          - loaddate
          - recordsource
          - ...

Regards, Marcin

[github-actions[bot]]

This issue is stale because it has been open for 90 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue. Otherwise it will be closed in 14 days