Skip to content

DBT: Dbt Tests

DBT model name: dbt_tests

Explore dependencies/lineage: link

Description

Metadata about tests in the project, including configuration and properties from the dbt graph. Each row contains information about a single test. 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 test.
database_name string The tested model database name.
schema_name string The tested model schema name.
name string The test name.
short_name string
alias string
test_column_name string The name of the tested column.
severity string
warn_if string
error_if string
test_params string
test_namespace string
tags string
model_tags string
model_owners string
meta string
depends_on_macros string
depends_on_nodes string
parent_model_unique_id string
description string
package_name string
type 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_tests_empty_table_query
  • upload_dbt_tests

No called script or script source not found.

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