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

DBT test name: dbt_utils_not_empty_string_seipcs_brazil_soy_v2_6_0_2016_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_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_2016_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_36663637d300fa79f7b72c53e67e574c") }}

    with

    all_values as (

        select 


            trim(IMPORTER) as IMPORTER

        from "trase_production"."main_brazil_soy"."seipcs_brazil_soy_v2_6_0_2016_with_exporter"

    ),

    errors as (

        select * from all_values
        where IMPORTER = ''

    )

    select * from errors