DBT Test: Dbt Utils Not Empty String Seipcs Brazil Soy V2 6 1 2021 With Exporter Importer

DBT test name: dbt_utils_not_empty_string_seipcs_brazil_soy_v2_6_1_2021_with_exporter_IMPORTER

DBT details

• Kind: generic (not_empty_string)

• Column under test: IMPORTER

• Test file: trase/data_pipeline/models/brazil/soy/sei_pcs/v2_6_1/with_exporter/_schema_brazil_soy_seipcs_v2_6_1_with_exporter.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• seipcs_brazil_soy_v2_6_1_2021_with_exporter

Macros

• test_not_empty_string
• get_where_subquery

{{ dbt_utils.test_not_empty_string(**_dbt_generic_test_kwargs) }}{{ config(alias="dbt_utils_not_empty_string_sei_5214d2d6f60026045df5a336908083c2") }}

    with

    all_values as (

        select 


            trim(IMPORTER) as IMPORTER

        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_1_2021_with_exporter"

    ),

    errors as (

        select * from all_values
        where IMPORTER = ''

    )

    select * from errors