Skip to main content

Add your description here

Project description

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.

🎬 The Story: Why This Library Exists

"Every data pipeline is a story. Every transformation, a chapter. But even the best tales can hide errors between the lines."

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.

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.

This is pytest-dbt-duckdb:

  • ✅ 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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pytest_dbt_duckdb-0.1.4.tar.gz (268.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pytest_dbt_duckdb-0.1.4-py3-none-any.whl (13.9 kB view details)

Uploaded Python 3

File details

Details for the file pytest_dbt_duckdb-0.1.4.tar.gz.

File metadata

  • Download URL: pytest_dbt_duckdb-0.1.4.tar.gz
  • Upload date:
  • Size: 268.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.5.29

File hashes

Hashes for pytest_dbt_duckdb-0.1.4.tar.gz
Algorithm Hash digest
SHA256 b009669cce94a2e1f03a8c28b6c8c308516f31da57e2b7c450324cf42f11c6c8
MD5 47f429e1a4533fd6f73425c43bb07130
BLAKE2b-256 272b82c4e80ea4d2c5e0cdb5f9d505c452bd26153aa4550e31ff458053bfebfb

See more details on using hashes here.

File details

Details for the file pytest_dbt_duckdb-0.1.4-py3-none-any.whl.

File metadata

File hashes

Hashes for pytest_dbt_duckdb-0.1.4-py3-none-any.whl
Algorithm Hash digest
SHA256 93819f95a8cf10ddaf336daedb36904f5221ea408b8c123fa6cc91bb2ea07c4a
MD5 9f3b6537e23dabc89f691e8e61640580
BLAKE2b-256 b90f3cdc2060330d7ae1144d8b48c2485734930a6cd70881e4aac95189142032

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page