DBT Test: Dbt Expectations Expect Column Unique Value Count To Be Between Brazil Mdic Port 2023 Mdic Bol Port Group 40 1

DBT test name: dbt_expectations_expect_column_unique_value_count_to_be_between_brazil_mdic_port_2023_mdic_bol_port_group__40__1

DBT details

• Kind: generic (expect_column_unique_value_count_to_be_between)

• Column under test: mdic_bol_port_group

• Test file: trase/data_pipeline/models/brazil/trade/mdic/port/_schema.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• brazil_mdic_port_2023

Macros

• test_expect_column_unique_value_count_to_be_between
• get_where_subquery

{{ dbt_expectations.test_expect_column_unique_value_count_to_be_between(**_dbt_generic_test_kwargs) }}{{ config(alias="dbt_expectations_expect_column_89de5f3d3ce5964f97e156b9a290782b") }}

    with grouped_expression as (
    select




( 1=1 and count(distinct mdic_bol_port_group) >= 1 and count(distinct mdic_bol_port_group) <= 40
)
 as expression


    from "memory"."main"."brazil_mdic_port_2023"


),
validation_errors as (

    select
        *
    from
        grouped_expression
    where
        not(expression = true)

)

select *
from validation_errors