Skip to content

DBT Test: Unique Postgres Countries Iso Numeric Code

DBT test name: unique_postgres_countries_iso_numeric_code

DBT details


Description

No description


Details

Models

Macros

  • test_unique
  • get_where_subquery
{{ test_unique(**_dbt_generic_test_kwargs) }}
select
    iso_numeric_code as unique_field,
    count(*) as n_records

from "trase_production"."main"."postgres_countries"
where iso_numeric_code is not null
group by iso_numeric_code
having count(*) > 1