DBT Test: Constant Within Group Indonesia Wood Pulp V3 2 0 Pulpwood Concessions 3 1 Node Type Name Node Type Slug

DBT test name: constant_within_group_indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_1_node_type_name__node_type_slug

DBT details

• Kind: generic (constant_within_group)

• Column under test: node_type_name

• Test file: trase/data_pipeline/models/indonesia/wood_pulp/data_packages/indonesia_wood_pulp_v3_2_0/_schema.yml

• Original dbt_docs

• Tags: indonesia, indonesia_wood_pulp_v3_2_0_data_package, mock_model, wood_pulp

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_1

Macros

• test_constant_within_group
• get_where_subquery

{{ test_constant_within_group(**_dbt_generic_test_kwargs) }}{{ config(tags=['mock_model', 'indonesia', 'wood_pulp', 'indonesia_wood_pulp_v3_2_0_data_package'],alias="constant_within_group_indonesi_c6a6bc7af2bce07822803f14b6ba96b9") }}

  -- Generate the group by clause dynamically




  with grouped as (
    select

        node_type_slug,

      count(distinct node_type_name) as distinct_count
    from "memory"."main"."indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_1"

      group by node_type_slug

  )

  select *
  from grouped
  where distinct_count > 1