PyTest dbt Duckdb 🦆
Fearless testing for dbt models, powered by DuckDB.
What is this?
pytest-dbt-duckdb is an open-source testing framework that allows you to validate dbt models end-to-end, using DuckDB as an in-memory execution engine. Designed for speed, portability, and CI/CD automation, it enables you to test dbt transformations before deployment, ensuring trust in your data.
🩺 Why This Exists
"Assumptions are dangerous." An untested model is a ticking time bomb—silent, unseen, but waiting to fail at the worst possible moment. This library ensures your transformations, dependencies, and outputs are battle-tested before deployment.
💡 Data must be tested, not trusted.
Modern analytics teams move fast—but in their race to ship, they often skip a crucial step: rigorous testing. A broken transformation can mean misreported revenue, misleading product insights, or silent failures that creep into dashboards.
"Each dbt model untested is a story unfinished."
Here, in the shadows of SQL models and YAML configurations, we forge a guardian—a pytest plugin that ensures every dbt model is battle-tested, validated, and ready before it touches production.
With DuckDB as the testing engine, you can:
- Define test cases with simple YAML scenarios.
- Execute them in DuckDB, locally and instantly—no warehouse needed.
- Integrate with CI/CD pipelines, catching errors before deployment.
- Extend with custom DuckDB functions for specialized assertions.
Data must be tested, not trusted. Let’s test fearlessly.
🚀 Who is this for?
Whether you are a craftsman of data or a guardian of analytics, this library is your lantern in the dark, guiding you toward precision and reliability.
- Data Engineers → Validate dbt models before they reach production.
- Analytics Engineers → Ensure clean, tested data in dashboards.
- CI/CD Developers → Automate SQL testing in pull requests.
🎯 Key Features
| Feature | Description |
|---|---|
| ✅ Fast Testing | Runs entirely in DuckDB—no warehouse costs. |
| 🛠️ YAML-Based Tests | Define test scenarios using declarative YAML. |
| ♻️ CI/CD Ready | Seamless integration with GitHub Actions, Jenkins, GitLab CI/CD. |
| 🔌 Custom Functions | Extend with user-defined DuckDB functions. |
| 🧪 Snapshot Testing | Compare actual vs. expected outputs with precision. |
| 🏷️ Extra dbt Args | Pass arbitrary dbt CLI flags (e.g. microbatch date windows) to both dbt seed and dbt build, per scenario. |
How It Works
➡️ See the Usage Section
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pytest_dbt_duckdb-0.2.1.tar.gz.
File metadata
- Download URL: pytest_dbt_duckdb-0.2.1.tar.gz
- Upload date:
- Size: 322.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
uv/0.12.5 {"installer":{"name":"uv","version":"0.12.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9330269bd114b1b30affa91cd2d71d2715658e7e2e0b620718f919db89eaf97b
|
|
| MD5 |
044563348470343e9ce3841aab2c05fb
|
|
| BLAKE2b-256 |
325ea62a0307795957d48ea9fd55fcc60cbdd7b3a317433278f97a2dd31a0f8a
|
File details
Details for the file pytest_dbt_duckdb-0.2.1-py3-none-any.whl.
File metadata
- Download URL: pytest_dbt_duckdb-0.2.1-py3-none-any.whl
- Upload date:
- Size: 20.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
uv/0.12.5 {"installer":{"name":"uv","version":"0.12.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
0049c0d23684319e4e295b6ad61e75f017eabed855c4ebadd83e3e6e99613768
|
|
| MD5 |
21e54747304a5865c33618181ea89d0c
|
|
| BLAKE2b-256 |
a52d042ac4a70ae644ad48e41d6bda325ec4451cc15eee296a7a72041f337e09
|
