DBT Test: Accepted Values Main Economic Blocs Economic Bloc Trase Id Afcfta Asean Eu Gcc Mercosur Nafta Usmca

DBT test name: accepted_values_main_economic_blocs_economic_bloc_trase_id__AFCFTA__ASEAN__EU__GCC__MERCOSUR__NAFTA__USMCA

DBT details

• Kind: generic (accepted_values)

• Column under test: economic_bloc_trase_id

• 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_accepted_values
• get_where_subquery

{{ test_accepted_values(**_dbt_generic_test_kwargs) }}{{ config(alias="accepted_values_main_economic__b5f20cd1d8b02ca68eed0100284c2fed") }}

with all_values as (

    select
        economic_bloc_trase_id as value_field,
        count(*) as n_records

    from "memory"."main"."main_economic_blocs"
    group by economic_bloc_trase_id

)

select *
from all_values
where value_field not in (
    'AFCFTA','ASEAN','EU','GCC','MERCOSUR','NAFTA','USMCA'
)