# Ignoring the columns while comparing two models

**URL:** <https://discourse.getdbt.com/t/ignoring-the-columns-while-comparing-two-models/8219>\
**Category:** Help\
**Tags:** testing, bigquery\
**Created:** [May 10, 2023, 12:52pm UTC](https://discourse.getdbt.com/t/ignoring-the-columns-while-comparing-two-models/8219 "2023-05-10T12:52:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajeshpaila](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@rajeshpaila](https://discourse.getdbt.com/u/rajeshpaila)\
**Post date:** [May 10, 2023, 12:52pm UTC](https://discourse.getdbt.com/t/ignoring-the-columns-while-comparing-two-models/8219/1 "2023-05-10T12:52:32Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![brunoszdl](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/brunoszdl/32/4113_2.png) [@brunoszdl](https://discourse.getdbt.com/u/brunoszdl)\
**Post date:** [May 10, 2023, 5:56pm UTC](https://discourse.getdbt.com/t/ignoring-the-columns-while-comparing-two-models/8219/2 "2023-05-10T17:56:24Z")

</div>

You can use compare relations from dbt\_audit\_helper

> **[GitHub - dbt-labs/dbt-audit-helper: Useful macros when performing data audits](https://github.com/dbt-labs/dbt-audit-helper#compare_relations-source)**
>
> Useful macros when performing data audits. Contribute to dbt-labs/dbt-audit-helper development by creating an account on GitHub.

and use the exclude\_columns parameter