DBT Test: Source Unique Trase-Storage-Raw Diet Trase Coffee 2020 Trader Group Parents Trader Name

DBT test name: source_unique_trase-storage-raw_diet_trase_coffee_2020_trader_group_parents_trader_name

DBT details

• Kind: generic (unique)

• Column under test: trader_name

• Test file: trase/data_pipeline/models/diet_trase/coffee_traders/_sources.yml

• Original dbt_docs

• Tags: 2020, coffee, diet-trase, traders, world

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Sources

• diet_trase_coffee_2020_trader_group_parents

Macros

• test_unique
• get_where_subquery

{{ test_unique(**_dbt_generic_test_kwargs) }}{{ config(alias="source_unique_trase-storage-ra_12b7793ad19d06c20d82d984dfc2b662") }}

select
    trader_name as unique_field,
    count(*) as n_records

from read_xlsx('s3://trase-storage/diet-trase/coffee_traders/parents_of_traders_2026_05_25.xlsx', all_varchar=true, sheet='parents_of_trader_groups')
where trader_name is not null
group by trader_name
having count(*) > 1