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

DBT test name: dbt_utils_not_empty_string_seipcs_brazil_soy_v2_6_1_2022_with_exporter_IMPORTER_GROUP

DBT details

• Kind: generic (not_empty_string)

• Column under test: IMPORTER_GROUP

• 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_2022_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_ab9591675629605e27ca332cfc0eaab5") }}

    with

    all_values as (

        select 


            trim(IMPORTER_GROUP) as IMPORTER_GROUP

        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_1_2022_with_exporter"

    ),

    errors as (

        select * from all_values
        where IMPORTER_GROUP = ''

    )

    select * from errors