Migrate dbt tests to AnomalyArmor

What the recipe does

The community dbt-odcs package walks every resource file in your dbt project, reads schema.yml test entries, and emits a single ODCS v3.1.0 YAML document. Paste the output into /migrate/soda (the shared ODCS entry point) and every rule applies against your tables after signup.

• not_null → ODCS not_null
• unique → ODCS unique
• accepted_values → ODCS in_set
• relationships → ODCS foreign_key
• Generic tests (custom macros) → flagged for manual review

Install

The dbt-odcs package is open source and maintained by the ODCS community.

pip install dbt-odcs

The recipe

Save as dbt_to_odcs.py in your dbt project root and pipe the output to a YAML file.

# Translate dbt schema.yml tests to ODCS YAML via the dbt-odcs package.
# Run from your dbt project root.
from dbt_odcs import compile_to_odcs
import yaml

# Pass your dbt project path; compile_to_odcs loads schema.yml entries
# across all resource files and returns a dict in ODCS v3.1.0 shape.
odcs = compile_to_odcs(
    project_dir=".",
    profiles_dir="~/.dbt",
    contract_name="my_warehouse",
)

print(yaml.safe_dump(odcs, sort_keys=False))

Then run: python dbt_to_odcs.py > contract.yaml and paste the resulting YAML into /migrate/soda.