Skip to main content

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 during dbt 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 to nodes and sources in the manifest
  • metadata
    • type: table, view, etc.
    • database
    • schema
    • name
    • comment
    • owner
  • columns (array)
    • name
    • type: data type
    • comment
    • index: ordinal
  • stats: differs by database and relation type
0
Loading