DBT Test: Main Economic Blocs Unique Country And Bloc

DBT test name: main_economic_blocs_unique_country_and_bloc

DBT details

• Kind: generic (unique_combination_of_columns)

• Test file: trase/data_pipeline/models/world/metadata/economic_blocs/_schema_world_metadata_economic_blocs.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• main_economic_blocs

Macros

• test_unique_combination_of_columns
• get_where_subquery

{{ dbt_utils.test_unique_combination_of_columns(**_dbt_generic_test_kwargs) }}

with validation_errors as (

    select
        country_iso2, economic_bloc_trase_id
    from "memory"."main"."main_economic_blocs"
    group by country_iso2, economic_bloc_trase_id
    having count(*) > 1

)

select *
from validation_errors