DBT Test: Main Economic Blocs Country Names Match Postgres Countries

DBT test name: main_economic_blocs_country_names_match_postgres_countries

DBT details

• Kind: generic (join_and_check_values)

• Test file: trase/data_pipeline/models/world/metadata/economic_blocs/_schema_world_metadata_economic_blocs.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• postgres_countries
• main_economic_blocs

Macros

• test_join_and_check_values
• get_where_subquery

{{ test_join_and_check_values(**_dbt_generic_test_kwargs) }}

    WITH
        l AS (
            SELECT DISTINCT

                    country_iso2 AS _country_iso2,


                    country_name

            FROM "memory"."main"."main_economic_blocs"

        )
        , r AS (
            SELECT DISTINCT

                    country_trase_id AS _country_trase_id,


                    country_name

            FROM "memory"."main"."postgres_countries"

        )
    SELECT *
    FROM l
    LEFT JOIN r
    ON

            l._country_iso2 = r._country_trase_id

    WHERE upper(strip_accents(l.country_name)) IS DISTINCT FROM r.country_name