What causes DbtRuntimeError (show)?

The model references a ref() or source() that does not exist in the target environment. A Jinja compilation error in the model prevents the SQL from being generated. The dbt runner does not have SELECT permission on one or more source tables referenced by the model. The --limit flag was not specified and the model generates a very large result, causing a timeout. The model uses database-specific syntax that is not supported in the current warehouse target

How do I fix DbtRuntimeError (show)?

Run dbt compile --select first to isolate compilation errors from execution errors.. Verify all ref() and source() dependencies exist in the target schema by running dbt ls.. Check connection and permissions with dbt debug before running dbt show.. Use dbt show --select --limit 10 to preview a small result set and avoid timeouts.. Review the compiled SQL in target/compiled/ to identify any syntax errors before execution.

Low severityexecution

Power BI Refresh Error:
DbtRuntimeError (show)

What does this error mean?

The dbt show command, which previews the first N rows of a model's output without materializing it, failed to execute. Failures are typically caused by compilation errors in the model, connection issues, or insufficient permissions on source tables.

Common causes

1The model references a ref() or source() that does not exist in the target environment
2A Jinja compilation error in the model prevents the SQL from being generated
3The dbt runner does not have SELECT permission on one or more source tables referenced by the model
4The --limit flag was not specified and the model generates a very large result, causing a timeout
5The model uses database-specific syntax that is not supported in the current warehouse target

How to fix it

1Run dbt compile --select <model> first to isolate compilation errors from execution errors.
2Verify all ref() and source() dependencies exist in the target schema by running dbt ls.
3Check connection and permissions with dbt debug before running dbt show.
4Use dbt show --select <model> --limit 10 to preview a small result set and avoid timeouts.
5Review the compiled SQL in target/compiled/ to identify any syntax errors before execution.

Frequently asked questions

Does dbt show materialize the model to the database?

No. dbt show executes the model's SQL and returns the preview directly to the terminal without writing to the database. It is a read-only operation.

Can I use dbt show to preview a model with inline variables?

Yes — pass variables with --vars: dbt show --select my_model --vars '{date_column: updated_at}' --limit 5. Variables resolve the same way as in a normal dbt run.