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

DBT test name: constant_within_group_diet_trase_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/diet_trase/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• diet_trase_coffee_2020

Macros

• test_constant_within_group
• get_where_subquery

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

  -- Generate the group by clause dynamically




  with grouped as (
    select

        country_of_production_iso2,

      count(distinct decision_tree_branch) as distinct_count
    from "trase_production"."main"."diet_trase_coffee_2020"

      group by country_of_production_iso2

  )

  select *
  from grouped
  where distinct_count > 1