DBT Test: Expect Column Value If And Only If Seipcs Brazil Soy V2 6 0 2018 With Exporter Port Of Export Branch Domestic Processed Domestically

DBT test name: expect_column_value_if_and_only_if_seipcs_brazil_soy_v2_6_0_2018_with_exporter_PORT_OF_EXPORT__BRANCH_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/sei_pcs/v2_6_0/with_exporter/_schema_brazil_soy_seipcs_v2_6_0_with_exporter.yml

• Original dbt_docs

• Tags: brazil_soy_v2_6_with_exporter_domestic

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• seipcs_brazil_soy_v2_6_0_2018_with_exporter

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(tags=['brazil_soy_v2_6_with_exporter_domestic'],limit=10,alias="expect_column_value_if_and_onl_690d8b7cf90ba27922bc07c1f340296d") }}

with all_values as ( select * from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2018_with_exporter" )
select * from all_values
where ( BRANCH = 'DOMESTIC' )
   != ( all_values.PORT_OF_EXPORT = 'PROCESSED DOMESTICALLY')