DBT Test: Expect Column Value If And Only If Seipcs Brazil Soy V2 6 0 2017 With Exporter Importer Group Branch Domestic Processed Domestically

DBT test name: expect_column_value_if_and_only_if_seipcs_brazil_soy_v2_6_0_2017_with_exporter_IMPORTER_GROUP__BRANCH_DOMESTIC___PROCESSED_DOMESTICALLY

DBT details

• Kind: generic (expect_column_value_if_and_only_if)

• Column under test: IMPORTER_GROUP

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

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