data-tests

An example of how to check data quality using DBT and DuckDB.

Installation

Virtual Environment

Install uv to create the virtual environment:

pip install uv

Create the virtual environment and activate it:

uv venv
source .venv/bin/activate

Install the dependencies:

uv pip install -r requirements.txt

DBT

Initialize the DBT project:

dbt init data_tests

Select duckdb as the database (option 1).

Move your profiles.yml file to the data_tests folder:

mv ~/.dbt/profiles.yml data_tests/

Developer notes

VSCode extensions

• SQLTools
• DuckDB Driver for SQLTools