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

DBT test name: dbt_utils_expression_is_true_global_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/world/global_coffee/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

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

select
    *
from (select * from "memory"."main"."global_coffee_2020" where is_domestic is not true) dbt_subquery

where not(mass_tonnes_raw_equivalent >= mass_tonnes)