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

DBT test name: expect_column_value_if_and_only_if_seipcs_brazil_soy_v2_6_1_2021_with_exporter_IMPORTER__BRANCH_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/sei_pcs/v2_6_1/with_exporter/_schema_brazil_soy_seipcs_v2_6_1_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_1_2021_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_7698f7b6a9ea1fda59f4b7331e34d742") }}

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