Compare dbt models and warehouse relations before trusting migration parity with dbt-audit-helper

Lets an agent run dbt parity checks, relation diffs, and row or value comparisons so refactors and source swaps can be verified before rollout.

Prerequisites

dbt Core, warehouse credentials, dbt-audit-helper package

Installation

Requirements and caveats from upstream:

• Each relation must have the same columns with the same names, but they do not have to be in the same order.
• Each relation must have the same columns with the same names, but they do not have to be in the same order. Build long lists with a few exclusions with dbt_utils.get_filtered_columns_in_relation, or pass None and the...
• Each relation must have the same columns with the same names, but they do not have to be in the same order. Use exclude_columns if some columns only exist in one relation.

Basic usage or getting-started notes:

• Advanced Usage

• New to dbt packages? Read more about them here.

• Include this package in your packages.yml file — check here for the latest version number.

• Source: https://github.com/dbt-labs/dbt-audit-helper

• Extracted from upstream docs: https://raw.githubusercontent.com/dbt-labs/dbt-audit-helper/HEAD/README.md

Documentation

• https://hub.getdbt.com/dbt-labs/audit_helper/latest/

Source

• Agent Skill Exchange