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

DBT test name: dbt_utils_expression_is_true_diet_trase_coffee_2020_mass_tonnes___0

DBT details

• Kind: generic (expression_is_true)

• Column under test: mass_tonnes

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

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

where not(mass_tonnes >0)