DBT Test: Indonesia Wood Pulp Sei Pcs Supplier Names

DBT test name: indonesia_wood_pulp_sei_pcs_supplier_names

DBT details

• Kind: generic (join_and_check_values)

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

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• indonesia_wood_pulp_companies_align_names_aligned_names_hti_v2025
• wood_pulp_ind_v3_2_0_2025_post_embedding_quant

Macros

• test_join_and_check_values
• get_where_subquery

{{ test_join_and_check_values(**_dbt_generic_test_kwargs) }}

    WITH
        l AS (
            SELECT DISTINCT

                    SUPPLIER_ID AS _supplier_id,


                    SUPPLIER

            FROM "trase_production"."main"."wood_pulp_ind_v3_2_0_2025_post_embedding_quant"

        )
        , r AS (
            SELECT DISTINCT

                    ID AS _id,


                    CONC_FRONTEND

            FROM "trase_production"."main"."indonesia_wood_pulp_companies_align_names_aligned_names_hti_v2025"

        )
    SELECT *
    FROM l
    INNER JOIN r
    ON

            l._supplier_id = r._id

    WHERE l.supplier <> r.conc_frontend