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

DBT test name: dbt_utils_not_empty_string_seipcs_brazil_soy_v2_6_1_2022_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_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_77ca507fa0d844ebf70d14f0ea63d0c2") }}

    with

    all_values as (

        select 


            trim(IMPORTER) as IMPORTER

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

    ),

    errors as (

        select * from all_values
        where IMPORTER = ''

    )

    select * from errors