Skip to content

DBT: Dbt Snapshots

DBT model name: dbt_snapshots

Explore dependencies/lineage: link

Description

Metadata about snapshots in the project, including configuration and properties from the dbt graph. Each row contains information about a single snapshot. 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
alias string
checksum string
materialization string
tags string
meta string
owner string
database_name string
schema_name string
depends_on_macros string
depends_on_nodes string
description string
name string
package_name string
original_path string
path string
generated_at string

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_snapshots

No called script or script source not found.

{{
    config(
        materialized="incremental",
        transient=False,
        post_hook="{{ elementary.upload_dbt_snapshots() }}",
        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() }}