Skip to content

dbt core integration

Ivan Zhang edited this page Oct 25, 2023 · 2 revisions

While dbt is a largely SQL-based data pipelining tool, Panda Patrol is compatible through the recently released dbt Python models and dbt-fal which extends dbt's Python functionality. To use Panda Patrol with dbt, you will need to install dbt-fal and configure your dbt project to use it. Panda Patrols can then be used in the same manner as the other data pipeline tools. See examples/dbt_pipeline to see a complete dbt example.

Monitoring dbt tests

You may already be using dbt tests. To continuously monitor these tests, you can use the following bash command in your root dbt project directory:

python -m panda_patrol.dbt

This will start monitoring the target/run_results.json for changes and test results. This command polls at 5 second intervals for changes to the file. These changes are then surfaced in the Panda Patrol UI. The patrol group is the name of the view and the patrol name is in the following format: {column_name}.{test_name}.

❗IMPORTANT
Panda Patrol does not currently support dbt cloud.