DBT Test: Dbt Utils Unique Combination Of Columns Brazil Beef Exporters Enriched Year Exporter Cnpj Exporter

DBT test name: dbt_utils_unique_combination_of_columns_brazil_beef_exporters_enriched_YEAR__EXPORTER_CNPJ__EXPORTER

DBT details

• Kind: generic (unique_combination_of_columns)

• Test file: trase/data_pipeline/models/brazil/beef/sei_pcs/v2_2_1/_schema_sei_pcs_v2_2_1.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• brazil_beef_exporters_enriched

Macros

• test_unique_combination_of_columns
• get_where_subquery

{{ dbt_utils.test_unique_combination_of_columns(**_dbt_generic_test_kwargs) }}{{ config(alias="dbt_utils_unique_combination_o_7cfbc37d114a45794a8f8f3143063706") }}

with validation_errors as (

    select
        YEAR, EXPORTER_CNPJ, EXPORTER
    from "trase_production"."main_brazil"."brazil_beef_exporters_enriched"
    group by YEAR, EXPORTER_CNPJ, EXPORTER
    having count(*) > 1

)

select *
from validation_errors