DBT Test: Spatial Metrics Trase Id In Spatial Layers

DBT test name: spatial_metrics_trase_id_in_spatial_layers

DBT details

• Kind: generic (data_release_package_spatial_layer_reference)

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

• Original dbt_docs

• Tags: indonesia, indonesia_wood_pulp_v3_2_0_data_package, mock_model, wood_pulp

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• indonesia_wood_pulp_v3_2_0_country
• indonesia_wood_pulp_v3_2_0_province
• indonesia_wood_pulp_v3_2_0_kabupaten
• indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_0
• indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_1
• indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_2
• indonesia_wood_pulp_v3_2_0_spatial_metrics

Macros

• test_data_release_package_spatial_layer_reference
• get_where_subquery

{{ test_data_release_package_spatial_layer_reference(**_dbt_generic_test_kwargs) }}{{ config(tags=['mock_model', 'indonesia', 'wood_pulp', 'indonesia_wood_pulp_v3_2_0_data_package']) }}

    with spatial_layers as (

        select trase_id, year_start, year_end from "memory"."main"."indonesia_wood_pulp_v3_2_0_country"
        union all

        select trase_id, year_start, year_end from "memory"."main"."indonesia_wood_pulp_v3_2_0_province"
        union all

        select trase_id, year_start, year_end from "memory"."main"."indonesia_wood_pulp_v3_2_0_kabupaten"
        union all

        select trase_id, year_start, year_end from "memory"."main"."indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_0"
        union all

        select trase_id, year_start, year_end from "memory"."main"."indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_1"
        union all

        select trase_id, year_start, year_end from "memory"."main"."indonesia_wood_pulp_v3_2_0_pulpwood_concessions_3_2"

    )

    select distinct
        data_file.trase_id as trase_id,
        data_file.year as year
    from "memory"."main"."indonesia_wood_pulp_v3_2_0_spatial_metrics" as data_file
    where data_file.trase_id is not null
      and not exists (
          select 1
          from spatial_layers
          where spatial_layers.trase_id = data_file.trase_id
            and (spatial_layers.year_start is null
                 or spatial_layers.year_start <= data_file.year)
            and (spatial_layers.year_end is null
                 or spatial_layers.year_end >= data_file.year)
      )