DBT Test: Dbt Utils Relationships Where Global Coffee Full Coffee Production 2020 Geocode Geocode Ref Global Coffee Subnational Regions

DBT test name: dbt_utils_relationships_where_global_coffee_full_coffee_production_2020_geocode__geocode__ref_global_coffee_subnational_regions_

DBT details

• Kind: generic (relationships_where)

• Column under test: geocode

• Test file: trase/data_pipeline/models/world/global_coffee/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• global_coffee_subnational_regions
• global_coffee_full_coffee_production_2020

Macros

• test_relationships_where
• get_where_subquery

{{ dbt_utils.test_relationships_where(**_dbt_generic_test_kwargs) }}{{ config(alias="dbt_utils_relationships_where__11101cdfda2d20c2fe439c0bb7fe37a7") }}

with left_table as (

  select
    geocode as id

  from "memory"."main"."global_coffee_full_coffee_production_2020"

  where geocode is not null
    and 1=1

),

right_table as (

  select
    geocode as id

  from "memory"."main"."global_coffee_subnational_regions"

  where geocode is not null
    and 1=1

),

exceptions as (

  select
    left_table.id,
    right_table.id as right_id

  from left_table

  left join right_table
         on left_table.id = right_table.id

  where right_table.id is null

)

select * from exceptions