DBT Test: Constant Within Group Global Coffee 2020 Decision Tree Branch Country Of Production Iso2

DBT test name: constant_within_group_global_coffee_2020_decision_tree_branch__country_of_production_iso2

DBT details

• Kind: generic (constant_within_group)

• Column under test: decision_tree_branch

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

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• global_coffee_2020

Macros

• test_constant_within_group
• get_where_subquery

{{ test_constant_within_group(**_dbt_generic_test_kwargs) }}{{ config(alias="constant_within_group_global_c_a56edf2db5074cccd6d268b0149010f2") }}

  -- Generate the group by clause dynamically




  with grouped as (
    select

        country_of_production_iso2,

      count(distinct decision_tree_branch) as distinct_count
    from "memory"."main"."global_coffee_2020"

      group by country_of_production_iso2

  )

  select *
  from grouped
  where distinct_count > 1