DBT Test: Source Unique Source World Metadata Country Iso Codes Source Alpha 3

DBT test name: source_unique_source_world_metadata_country_iso_codes_source_alpha_3

DBT details

• Kind: generic (unique)

• Column under test: alpha_3

• Test file: trase/data_pipeline/models/world/metadata/codes/_sources_world_metadata.yml

• Original dbt_docs

• Tags: codes, original, world

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Sources

• country_iso_codes_source

Macros

• test_unique
• get_where_subquery

{{ test_unique(**_dbt_generic_test_kwargs) }}{{ config(alias="source_unique_source_world_met_26b699e7a40a8d7dfcdb3e1fb5b910d1") }}

select
    alpha_3 as unique_field,
    count(*) as n_records

from 's3://trase-storage/world/metadata/codes/country_iso_codes.parquet'
where alpha_3 is not null
group by alpha_3
having count(*) > 1