Skip to content

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

DBT test name: source_unique_source_world_metadata_country_iso_codes_source_alpha_2

DBT details


Description

No description


Details

Sources

Macros

  • test_unique
  • get_where_subquery
{{ test_unique(**_dbt_generic_test_kwargs) }}{{ config(alias="source_unique_source_world_met_8afb102e28fa63013daa506610ad8498") }}
select
    alpha_2 as unique_field,
    count(*) as n_records

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