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

DBT test name: constant_within_group_diet_trase_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/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_ae2e84fffda2d309c9d207b6048106d6") }}

  -- Generate the group by clause dynamically




  with grouped as (
    select

        country_of_production_iso2,

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

      group by country_of_production_iso2

  )

  select *
  from grouped
  where distinct_count > 1