DBT Test: All Columns Not Null Seipcs Brazil Soy V2 6 0 2019 With Exporter

DBT test name: all_columns_not_null_seipcs_brazil_soy_v2_6_0_2019_with_exporter_

DBT details

• Kind: generic (all_columns_not_null)

• Test file: trase/data_pipeline/models/brazil/soy/sei_pcs/v2_6_0/with_exporter/_schema_brazil_soy_seipcs_v2_6_0_with_exporter.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• seipcs_brazil_soy_v2_6_0_2019_with_exporter

Macros

• test_all_columns_not_null
• get_where_subquery

{{ test_all_columns_not_null(**_dbt_generic_test_kwargs) }}{{ config(alias="all_columns_not_null_seipcs_br_6499dd60a4e73660046a26adad6cc698") }}

    select 
        '"BIOME"' as column_name, 
        count(*) as c 
    from (
        select '"BIOME"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"BIOME"' is null
    ) as subquery_1
    having count(*) > 0
    union all
    select 
        '"BIOME_TRASE_ID"' as column_name, 
        count(*) as c 
    from (
        select '"BIOME_TRASE_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"BIOME_TRASE_ID"' is null
    ) as subquery_2
    having count(*) > 0
    union all
    select 
        '"CNPJ"' as column_name, 
        count(*) as c 
    from (
        select '"CNPJ"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"CNPJ"' is null
    ) as subquery_3
    having count(*) > 0
    union all
    select 
        '"COUNTRY_OF_FIRST_IMPORT"' as column_name, 
        count(*) as c 
    from (
        select '"COUNTRY_OF_FIRST_IMPORT"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"COUNTRY_OF_FIRST_IMPORT"' is null
    ) as subquery_4
    having count(*) > 0
    union all
    select 
        '"COUNTRY_OF_FIRST_IMPORT_TRASE_ID"' as column_name, 
        count(*) as c 
    from (
        select '"COUNTRY_OF_FIRST_IMPORT_TRASE_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"COUNTRY_OF_FIRST_IMPORT_TRASE_ID"' is null
    ) as subquery_5
    having count(*) > 0
    union all
    select 
        '"COUNTRY_OF_PRODUCTION"' as column_name, 
        count(*) as c 
    from (
        select '"COUNTRY_OF_PRODUCTION"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"COUNTRY_OF_PRODUCTION"' is null
    ) as subquery_6
    having count(*) > 0
    union all
    select 
        '"COUNTRY_OF_PRODUCTION_TRASE_ID"' as column_name, 
        count(*) as c 
    from (
        select '"COUNTRY_OF_PRODUCTION_TRASE_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"COUNTRY_OF_PRODUCTION_TRASE_ID"' is null
    ) as subquery_7
    having count(*) > 0
    union all
    select 
        '"BRANCH"' as column_name, 
        count(*) as c 
    from (
        select '"BRANCH"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"BRANCH"' is null
    ) as subquery_8
    having count(*) > 0
    union all
    select 
        '"ECONOMIC_BLOC"' as column_name, 
        count(*) as c 
    from (
        select '"ECONOMIC_BLOC"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"ECONOMIC_BLOC"' is null
    ) as subquery_9
    having count(*) > 0
    union all
    select 
        '"EXPORTER"' as column_name, 
        count(*) as c 
    from (
        select '"EXPORTER"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"EXPORTER"' is null
    ) as subquery_10
    having count(*) > 0
    union all
    select 
        '"EXPORTER_GROUP"' as column_name, 
        count(*) as c 
    from (
        select '"EXPORTER_GROUP"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"EXPORTER_GROUP"' is null
    ) as subquery_11
    having count(*) > 0
    union all
    select 
        '"EXPORTER_GROUP_ID"' as column_name, 
        count(*) as c 
    from (
        select '"EXPORTER_GROUP_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"EXPORTER_GROUP_ID"' is null
    ) as subquery_12
    having count(*) > 0
    union all
    select 
        '"EXPORTER_ID"' as column_name, 
        count(*) as c 
    from (
        select '"EXPORTER_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"EXPORTER_ID"' is null
    ) as subquery_13
    having count(*) > 0
    union all
    select 
        '"EXPORTER_TRASE_ID"' as column_name, 
        count(*) as c 
    from (
        select '"EXPORTER_TRASE_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"EXPORTER_TRASE_ID"' is null
    ) as subquery_14
    having count(*) > 0
    union all
    select 
        '"FOB"' as column_name, 
        count(*) as c 
    from (
        select '"FOB"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"FOB"' is null
    ) as subquery_15
    having count(*) > 0
    union all
    select 
        '"IMPORTER"' as column_name, 
        count(*) as c 
    from (
        select '"IMPORTER"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"IMPORTER"' is null
    ) as subquery_16
    having count(*) > 0
    union all
    select 
        '"IMPORTER_GROUP"' as column_name, 
        count(*) as c 
    from (
        select '"IMPORTER_GROUP"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"IMPORTER_GROUP"' is null
    ) as subquery_17
    having count(*) > 0
    union all
    select 
        '"IMPORTER_GROUP_ID"' as column_name, 
        count(*) as c 
    from (
        select '"IMPORTER_GROUP_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"IMPORTER_GROUP_ID"' is null
    ) as subquery_18
    having count(*) > 0
    union all
    select 
        '"IMPORTER_ID"' as column_name, 
        count(*) as c 
    from (
        select '"IMPORTER_ID"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"IMPORTER_ID"' is null
    ) as subquery_19
    having count(*) > 0
    union all
    select 
        '"LOGISTICS_HUB"' as column_name, 
        count(*) as c 
    from (
        select '"LOGISTICS_HUB"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"LOGISTICS_HUB"' is null
    ) as subquery_20
    having count(*) > 0
    union all
    select 
        '"LVL6_TRASE_ID_LH"' as column_name, 
        count(*) as c 
    from (
        select '"LVL6_TRASE_ID_LH"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"LVL6_TRASE_ID_LH"' is null
    ) as subquery_21
    having count(*) > 0
    union all
    select 
        '"MATCHED"' as column_name, 
        count(*) as c 
    from (
        select '"MATCHED"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"MATCHED"' is null
    ) as subquery_22
    having count(*) > 0
    union all
    select 
        '"LVL6_NAME_PROD"' as column_name, 
        count(*) as c 
    from (
        select '"LVL6_NAME_PROD"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"LVL6_NAME_PROD"' is null
    ) as subquery_23
    having count(*) > 0
    union all
    select 
        '"MUNICIPALITY_OF_PRODUCTION_NODE_SUB_TYPE"' as column_name, 
        count(*) as c 
    from (
        select '"MUNICIPALITY_OF_PRODUCTION_NODE_SUB_TYPE"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"MUNICIPALITY_OF_PRODUCTION_NODE_SUB_TYPE"' is null
    ) as subquery_24
    having count(*) > 0
    union all
    select 
        '"LVL6_TRASE_ID_PROD"' as column_name, 
        count(*) as c 
    from (
        select '"LVL6_TRASE_ID_PROD"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"LVL6_TRASE_ID_PROD"' is null
    ) as subquery_25
    having count(*) > 0
    union all
    select 
        '"PORT_OF_EXPORT"' as column_name, 
        count(*) as c 
    from (
        select '"PORT_OF_EXPORT"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"PORT_OF_EXPORT"' is null
    ) as subquery_26
    having count(*) > 0
    union all
    select 
        '"PRODUCT"' as column_name, 
        count(*) as c 
    from (
        select '"PRODUCT"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"PRODUCT"' is null
    ) as subquery_27
    having count(*) > 0
    union all
    select 
        '"STATE"' as column_name, 
        count(*) as c 
    from (
        select '"STATE"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"STATE"' is null
    ) as subquery_28
    having count(*) > 0
    union all
    select 
        '"STATE_NODE_SUB_TYPE"' as column_name, 
        count(*) as c 
    from (
        select '"STATE_NODE_SUB_TYPE"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"STATE_NODE_SUB_TYPE"' is null
    ) as subquery_29
    having count(*) > 0
    union all
    select 
        '"LVL3_TRASE_ID_PROD"' as column_name, 
        count(*) as c 
    from (
        select '"LVL3_TRASE_ID_PROD"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"LVL3_TRASE_ID_PROD"' is null
    ) as subquery_30
    having count(*) > 0
    union all
    select 
        '"TRASE_GEOCODE"' as column_name, 
        count(*) as c 
    from (
        select '"TRASE_GEOCODE"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"TRASE_GEOCODE"' is null
    ) as subquery_31
    having count(*) > 0
    union all
    select 
        '"VOLUME_RAW"' as column_name, 
        count(*) as c 
    from (
        select '"VOLUME_RAW"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"VOLUME_RAW"' is null
    ) as subquery_32
    having count(*) > 0
    union all
    select 
        '"VOLUME_PRODUCT"' as column_name, 
        count(*) as c 
    from (
        select '"VOLUME_PRODUCT"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"VOLUME_PRODUCT"' is null
    ) as subquery_33
    having count(*) > 0
    union all
    select 
        '"YEAR"' as column_name, 
        count(*) as c 
    from (
        select '"YEAR"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"YEAR"' is null
    ) as subquery_34
    having count(*) > 0
    union all
    select 
        '"IMPORTER_LABEL"' as column_name, 
        count(*) as c 
    from (
        select '"IMPORTER_LABEL"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"IMPORTER_LABEL"' is null
    ) as subquery_35
    having count(*) > 0
    union all
    select 
        '"EXPORTER_LABEL"' as column_name, 
        count(*) as c 
    from (
        select '"EXPORTER_LABEL"'
        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2019_with_exporter"
        where '"EXPORTER_LABEL"' is null
    ) as subquery_36
    having count(*) > 0