DBT Test: Dbt Utils Expression Is True Diet Trase Coffee 2020 Mass Tonnes Raw Equivalent Mass Tonnes

DBT test name: dbt_utils_expression_is_true_diet_trase_coffee_2020_mass_tonnes_raw_equivalent___mass_tonnes

DBT details

• Kind: generic (expression_is_true)

• Column under test: mass_tonnes_raw_equivalent

• 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_expression_is_true
• get_where_subquery
• test_expression_is_true

{{ dbt_utils.test_expression_is_true(**_dbt_generic_test_kwargs) }}{{ config(where="is_domestic is not true",alias="dbt_utils_expression_is_true_d_e34db77957cdd5b8f37ff4256fcf2fae") }}

select
    *
from (select * from "trase_production"."main"."diet_trase_coffee_2020" where is_domestic is not true) dbt_subquery

where not(mass_tonnes_raw_equivalent >= mass_tonnes)