DBT Test: Constant Within Group Global Coffee 2020 Linear Programming Status Country Of Production Iso2

DBT test name: constant_within_group_global_coffee_2020_linear_programming_status__country_of_production_iso2

DBT details

• Kind: generic (constant_within_group)

• Column under test: linear_programming_status

• 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_3726f074c2102b895826d00cee5265db") }}

  -- Generate the group by clause dynamically




  with grouped as (
    select

        country_of_production_iso2,

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

      group by country_of_production_iso2

  )

  select *
  from grouped
  where distinct_count > 1