Catalog JSON file
Current schema: v1
Produced by: docs generate
This file contains information from your data warehouseA data warehouse is a data management system used for data storage and computing that allows for analytics activities such as transforming and sharing data. about the tables and viewsA view (as opposed to a table) is a defined passthrough SQL query that can be run against a database (or data warehouse). produced and defined by the resources in your project. Today, dbt uses this file to populate metadata, such as column types and tableIn simplest terms, a table is the direct storage of data in rows and columns. Think excel sheet with raw values in each of the cells. statistics, in the docs site.
Top-level keys
metadata
nodes
: Dictionary containing information about database objects corresponding to dbt models, seeds, and snapshots.sources
: Dictionary containing information about database objects corresponding to dbt sources.errors
: Errors received while running metadata queries duringdbt docs generate
.
Resource details
Within sources
and nodes
, each dictionary key is a resource unique_id
. Each nested resource contains:
unique_id
:<resource_type>.<package>.<resource_name>
, same as dictionary key, maps tonodes
andsources
in the manifestmetadata
type
: table, view, etc.database
schema
name
comment
owner
columns
(array)name
type
: data typecomment
index
: ordinal
stats
: differs by database and relation type