Dbt auditing

First, add a packages yml file to your dbt project, if you don't have one already Inside the packages yml file, add the audit_helper package by copying and pasting the code below

Note that this file should be at the same level as your dbt_project

Run dbt deps in the command line to install the package (s)

Run dbt deps in the command line to install the package (s)

Packages get installed in the dbt_packages directory — by default this directory is ignored by git, to avoid duplicating the source code for the package

For more information on using packages in your dbt project, check out the dbt Documentation

When you run the dbt audit model, it will compare all columns, row by row

To count for the match, every column in a row from one source must exactly match a row from another source, as illustrated in the example in Figure 2 below: ,

You need to filter out records from one of the relations

Some columns must be renamed or recast in order to match

But since you only want to compare a few columns, it’s simpler to write the columns you want to compare rather than the columns you want to exclude

When you run the dbt audit model, it will compare all columns, row by row

Note that this file should be at the same level as your dbt_project

Run dbt deps in the command line to install the package (s)

When you run the dbt audit model, it will compare all columns, row by row

To count for the match, every column in a row from one source must exactly match a row from another source, as illustrated in the example in Figure 2 below:

You need to filter out records from one of the relations

Some columns must be renamed or recast in order to match

But since you only want to compare a few columns, it’s simpler to write the columns you want to compare rather than the columns you want to exclude

When you run the dbt audit model, it will compare all columns, row by row