DBT Test: Dbt Utils Unique Combination Of Columns Brazil Beef Zero Deforestation Commitments From Database 2010 2020 Year Biome Trase Id Slaughterhouse Trase Id Exporter Group

DBT test name: dbt_utils_unique_combination_of_columns_brazil_beef_zero_deforestation_commitments_from_database_2010_2020_year__biome_trase_id__slaughterhouse_trase_id__exporter_group

DBT details

• Kind: generic (unique_combination_of_columns)

• Test file: trase/data_pipeline/models/brazil/beef/indicators/out/q3_2025/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• brazil_beef_zero_deforestation_commitments_from_database_2010_2020

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_2385fd4c5e931670ff587384c53238d0") }}

with validation_errors as (

    select
        year, biome_trase_id, slaughterhouse_trase_id, exporter_group
    from "trase_production"."main_brazil"."brazil_beef_zero_deforestation_commitments_from_database_2010_2020"
    group by year, biome_trase_id, slaughterhouse_trase_id, exporter_group
    having count(*) > 1

)

select *
from validation_errors