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

DBT test name: expect_column_value_if_and_only_if_brazil_soy_v2_7_0_supply_chain_port_of_export__decision_tree_DOMESTIC___PROCESSED_DOMESTICALLY

DBT details

• Kind: generic (expect_column_value_if_and_only_if)

• Column under test: port_of_export

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

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.port_of_export = 'PROCESSED DOMESTICALLY')