DBT Test: Mill Sentinels Agree Id Palm V1 2 5

DBT test name: mill_sentinels_agree_id_palm_v1_2_5

DBT details

• Kind: generic (expect_column_value_if_and_only_if)

• Column under test: mill

• Test file: trase/data_pipeline/models/indonesia/palm_oil/sei_pcs/v1_2_5/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• indonesia_palm_oil_v1_2_5_for_ingestion

Macros

• test_expect_column_value_if_and_only_if
• get_where_subquery

{{ test_expect_column_value_if_and_only_if(**_dbt_generic_test_kwargs) }}

with all_values as ( select * from "memory"."main"."indonesia_palm_oil_v1_2_5_for_ingestion" )
select * from all_values
where ( mill_trase_id = 'ID-PALM-MILL-X' )
   != ( all_values.mill = 'UNKNOWN')