Hello all! I’ve been working on a port of the tests from the Great Expectations package to dbt. Turns out most of the expectations, except those relying on more complex statistical functions, can be ported to SQL without issue.
This allows dbt users that have been eyeing the Great Expectations Python package to use some of these tests directly in their dbt pipelines without having to deal with the potential complexities of integrating a Python-based testing workflow.
This package is currently in alpha release - that means ready for testing, but bound to have some changes to its API and functionality.
I’d love it if the dbt community would check it out and provide feedback via the Github issues page, or contribute directly via PRs. In particular, there are a few regex-based string matching tests I haven’t had a chance to implement yet.
(The project contains a set of integration tests, similar to what the dbt-utils package is doing - happy to walk anyone through how to set that up.)