Skip to content

DBT: Dbt Sources

DBT model name: dbt_sources

Explore dependencies/lineage: link

Description

Metadata about sources in the project, including configuration and properties from the dbt graph. Each row contains information about a single source. 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
database_name string
schema_name string
source_name string
name string
identifier string
loaded_at_field string
freshness_warn_after string
freshness_error_after string
freshness_filter string
relation_name string
tags string
meta string
owner string
package_name string
original_path string
path string
source_description string
description string
generated_at string

No data tests defined 🧐

Models

Macros

  • get_config_var
  • get_default_table_type
  • get_default_incremental_strategy
  • get_dbt_sources_empty_table_query
  • upload_dbt_sources

No called script or script source not found.

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