Skip to content

dbt Constraints v0.2.0
Compare
Choose a tag to compare
@sfc-gh-dflippo sfc-gh-dflippo released this 26 Apr 12:30
· 124 commits to main since this release
0.2.0
e3c2e5e
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

New Features

  • This release adds optional support for constraints on sources. These are not enabled by default but can be enabled using a variable.
  • In order to add source constraint support, two additional macros are now needed for each database because we now need to verify database permissions. It could be presumed that dbt projects had OWNERSHIP on models but that is not something that should be assumed for sources. Each constraint with a source will now lookup OWNERSHIP and REFERENCES permissions as necessary for PK, UK, and FK. For performance reasons I have skipped checking permissions for constraints that only have models.
  • Documentation has been updated and a new TROUBLESHOOTING.md file has been added with all the logged error messages and some tips for how to resolve the message. These are non-fatal messages such ask skipping a FK because a PK/UK does not exist.

Fixes

None

Known issues

None

Assets 2
Loading