DBT Test: Dbt Expectations Expect Column Sum To Be Between Brazil Soy V2 7 0 Supply Chain Co2 Net Emissions Planting Year 5y Amortised Exposure Tco2e Year 0 True

DBT test name: dbt_expectations_expect_column_sum_to_be_between_brazil_soy_v2_7_0_supply_chain_co2_net_emissions_planting_year_5y_amortised_exposure_tco2e__year__0__True

DBT details

• Kind: generic (expect_column_sum_to_be_between)

• Column under test: co2_net_emissions_planting_year_5y_amortised_exposure_tco2e

• Test file: trase/data_pipeline/models/brazil/soy/data_packages/brazil_soy_v2_7_0/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• brazil_soy_v2_7_0_supply_chain

Macros

• test_expect_column_sum_to_be_between
• get_where_subquery

{{ dbt_expectations.test_expect_column_sum_to_be_between(**_dbt_generic_test_kwargs) }}{{ config(alias="dbt_expectations_expect_column_cbba0bbb3d1cc4aa8d8ac469473a6a97") }}

    with grouped_expression as (
    select

        year as col_1,




( 1=1 and sum(co2_net_emissions_planting_year_5y_amortised_exposure_tco2e) > 0
)
 as expression


    from "memory"."main"."brazil_soy_v2_7_0_supply_chain"

    group by
    year



),
validation_errors as (

    select
        *
    from
        grouped_expression
    where
        not(expression = true)

)

select *
from validation_errors