What causes DbtDocsCatalogError?

The dbt profile credentials lack permission to query the information schema or system catalog. A model was dropped from the warehouse but still exists in manifest.json, causing a lookup failure. The database session timed out while querying the catalog for large schemas. The warehouse connection is unavailable or the credentials in the profile expired

How do I fix DbtDocsCatalogError?

Step 1: Run dbt debug to confirm the warehouse connection and credentials are valid.. Step 2: Verify the service account has SELECT on INFORMATION_SCHEMA or the equivalent system catalog.. Step 3: Add --no-compile flag: dbt docs generate --no-compile to skip model compilation and only generate the catalog.. Step 4: If a specific schema is failing, exclude it using --exclude to narrow down the problem.. Step 5: For large schemas, increase the session timeout in the dbt profile.

Low severityexecution

Power BI Refresh Error:
DbtDocsCatalogError

What does this error mean?

The dbt docs generate command failed to produce a catalog.json because it could not query the information schema of the target database.

Common causes

1The dbt profile credentials lack permission to query the information schema or system catalog
2A model was dropped from the warehouse but still exists in manifest.json, causing a lookup failure
3The database session timed out while querying the catalog for large schemas
4The warehouse connection is unavailable or the credentials in the profile expired

How to fix it

1Step 1: Run dbt debug to confirm the warehouse connection and credentials are valid.
2Step 2: Verify the service account has SELECT on INFORMATION_SCHEMA or the equivalent system catalog.
3Step 3: Add --no-compile flag: dbt docs generate --no-compile to skip model compilation and only generate the catalog.
4Step 4: If a specific schema is failing, exclude it using --exclude to narrow down the problem.
5Step 5: For large schemas, increase the session timeout in the dbt profile.

Frequently asked questions

What is catalog.json used for in dbt?

catalog.json contains metadata about all tables and columns materialized in the warehouse, enriching the dbt docs site with column descriptions and row counts. It is also used by some lineage and data catalog tools.

Can dbt docs generate fail silently?

It can exit with code 0 even if some nodes are missing from the catalog — check the command output for any 'WARNING' lines about nodes that could not be cataloged.