A curated collection of Agent Skills for working with dbt, to help AI agents understand and execute dbt workflows more effectively.
91
91%
Does it follow best practices?
Impact
Pending
No eval scenarios have been run
Advisory
Suggest reviewing before use
If you are prompted to fix a bug, start by reviewing the logs and artifacts from the most recent dbt invocation. See scripts/review_run_results.md for an example.
logs/dbt.log file contains all the queries that dbt ran, and additional logging. Recent errors will be at the bottom of the file.target/run_results.json file contains each model which ran in the most recent invocation, and whether they succeeded or not. See scripts/review_run_results for sample code.target/compiled directory contains the rendered model code as a select statement.target/run directory contains that rendered code inside of DDL statements such as CREATE TABLE AS SELECT.If the error came from the console, read the error message.
The error messages dbt produces will normally contain the type of error, and the file where the error occurred.
dbt project errors can have several root causes:
These are likely to be YAML or parsing errors:
error: dbt1013: YAML error: did not find expected key at line 14 column 7, while parsing a block mapping at line 11 column 5
--> models/anchor_tests.yml:14:7Encountered an error:
Parsing Error
Error reading jaffle_shop: anchor_tests.yml - Runtime Error
Syntax error near line 14These errors can be fixed by updating the impacted files, ensuring they conform to the correct YAML structure.
These are likely to be compilation or SQL errors, or a failing unit test:
error: dbt1005: Found duplicate model 'my_first_model'
--> models/my_first_model.sqlerror: dbt0101: mismatched input 'orders' expecting one of 'SELECT', 'TABLE', '('
--> models/marts/customers.sql:9:1 (target/compiled/models/marts/customers.sql:9:1)03:16:39 Failure in unit_test test_does_location_opened_at_trunc_to_date (models/staging/stg_locations.yml)
03:16:39
actual differs from expected:
@@,location_id,location_name,tax_rate,opened_date
,1 ,Vice City ,0.2 ,2016-09-01 00:00:00
→ ,2 ,San Andreas ,0.1 ,2079-10-27 00:00:00→2079-10-27 23:59:59.999900These should be fixed by updating the referenced files in the error message. Fix invalid SQL, and ensure that the transformations produce the desired output based on defined tests and documentation.
Invalid data is detected during execution of a dbt project, e.g. during dbt build, dbt test or dbt run.
03:29:09 Failure in test accepted_values_customers_customer_type__new__returning (models/marts/customers.yml)
03:29:09 Got 1 result, configured to fail if != 0
03:29:09
03:29:09 compiled code at target/compiled/jaffle_shop/models/marts/customers.yml/accepted_values_customers_customer_type__new__returning.sqlIt normally needs to be resolved by transforming the underlying data to match the test's expectations. Perform transformations as early in the DAG as possible, ideally in a staging layer.
Do not remove a test, or modify a test to pass, without explicit permission.
After making the necessary project changes, run the most efficient command that will validate the problem is solved.
dbt parse is fast and does not require warehouse resources. It will only identify dbt project misconfigurations. It is implicitly run in all other commands, so only explicitly invoke it if the issue was a project misconfiguration instead of invalid models or data.dbt compile --select broken_model is relatively fast and cheap to run. It will only identify SQL errors when using the dbt Fusion engine (version 2.0 and above).dbt build --select broken_model is the most reliable way to ensure that a model and its tests are passing, but will take a while and consume warehouse resources.When running commands that connect to the warehouse (everything except dbt parse), ALWAYS use a --select flag to avoid processing the entire dbt project and consuming excessive resources.
evals
scenarios
dbt-docs-arguments
dbt-docs-unit-test-fixtures
dbt-job-failure
dbt-unit-test-format-choice
example-yaml-error
fusion-migration-triage-basic
fusion-migration-triage-blocked
fusion-triage-cat-a-static-analysis
fusion-triage-cat-b-dict-meta-get
fusion-triage-cat-b-unexpected-config
fusion-triage-cat-b-unused-schema
fusion-triage-cat-b-yaml-syntax
fusion-triage-cat-c-hardcoded-fqn
src
tests
scripts
skills
dbt
skills
adding-dbt-unit-test
references
answering-natural-language-questions-with-dbt
building-dbt-semantic-layer
configuring-dbt-mcp-server
fetching-dbt-docs
scripts
running-dbt-commands
troubleshooting-dbt-job-errors
references
using-dbt-for-analytics-engineering
working-with-dbt-mesh
dbt-extras
skills
creating-mermaid-dbt-dag
dbt-migration
skills
migrating-dbt-core-to-fusion
migrating-dbt-project-across-platforms