Ignoring the columns while comparing two models

Help
,
1

Hi All,

How to ignore the columns while comparing two tables.

Currently we are comparing two tables using model dbt_utils.equality . But as per this model, it’s trying to comparing all the columns between source and target. As per my business condition, i need to ignore few columns from both source and target tables.
Is there any model/function we can use to ignoring the specific columns in source and target tables. currently we have 600 + columns in tables where we need to ignore around 20 to 25 columns.

2

You can use compare relations from dbt_audit_helper

and use the exclude_columns parameter