Skip to content

DBT Test: Unique Postgres Countries Fao Code

DBT test name: unique_postgres_countries_fao_code

DBT details


Description

No description


Details

Models

Macros

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

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