Skip to content

DBT: Dbt Models

DBT model name: dbt_models

Explore dependencies/lineage: link

Description

Metadata about models in the project, including configuration and properties from the dbt graph. Each row contains information about a single model. Data is loaded every time this model is executed. It is recommended to execute the model every time a change is merged to the project.

Details

Column Type Description
unique_id string The unique id of the model.
alias string
checksum string Model file checksum.
materialization string The model materialization config.
tags string Model tags property.
meta string The content of 'meta' property key.
owner string Model owner property (configured under 'meta' key).
database_name string The model database name.
schema_name string The model schema name.
depends_on_macros string The macros the model directly depends on.
depends_on_nodes string The nodes the model directly depends on.
description string Model description.
name string Model name.
package_name string Package name of the model.
original_path string Full path of the model file.
path string Short path of the model file.
generated_at string Update time of the table.

No data tests defined 🧐

Models

Macros

  • get_config_var
  • get_default_table_type
  • get_default_incremental_strategy
  • get_dbt_models_empty_table_query
  • upload_dbt_models

No called script or script source not found.

{{
    config(
        materialized="incremental",
        transient=False,
        post_hook="{{ elementary.upload_dbt_models() }}",
        unique_key="unique_id",
        on_schema_change="sync_all_columns",
        full_refresh=elementary.get_config_var("elementary_full_refresh"),
        table_type=elementary.get_default_table_type(),
        incremental_strategy=elementary.get_default_incremental_strategy(),
    )
}}

{{ elementary.get_dbt_models_empty_table_query() }}