DBT Test: Expect Column Value If And Only If Brazil Soy V2 7 0 Supply Chain Importer Decision Tree Domestic Processed Domestically

DBT test name: expect_column_value_if_and_only_if_brazil_soy_v2_7_0_supply_chain_importer__decision_tree_DOMESTIC___PROCESSED_DOMESTICALLY

DBT details

• Kind: generic (expect_column_value_if_and_only_if)

• Column under test: importer

• 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_value_if_and_only_if
• get_where_subquery

{{ test_expect_column_value_if_and_only_if(**_dbt_generic_test_kwargs) }}{{ config(limit=10,alias="expect_column_value_if_and_onl_6b69b515a976de21fb501eedad397c2e") }}

with all_values as ( select * from "memory"."main"."brazil_soy_v2_7_0_supply_chain" )
select * from all_values
where ( decision_tree = 'DOMESTIC' )
   != ( all_values.importer = 'PROCESSED DOMESTICALLY')