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

DBT test name: source_unique_trase-storage-raw_global_coffee_2020_trader_group_parents_trader_name

DBT details

• Kind: generic (unique)

• Column under test: trader_name

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

• Original dbt_docs

• Tags: 2020, coffee, global_coffee, traders, world

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Sources

• global_coffee_2020_trader_group_parents

Macros

• test_unique
• get_where_subquery

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

select
    trader_name as unique_field,
    count(*) as n_records

from read_xlsx('s3://trase-storage/world/global_coffee/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