DBT Test: Dbt Expectations Expect Column Unique Value Count To Be Between Brazil Mdic Port 2024 Mdic Bol Region Of Destination 10 1

DBT test name: dbt_expectations_expect_column_unique_value_count_to_be_between_brazil_mdic_port_2024_mdic_bol_region_of_destination__10__1

DBT details

• Kind: generic (expect_column_unique_value_count_to_be_between)

• Column under test: mdic_bol_region_of_destination

• 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_2024

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_06b4f9e7ca9cdef7f2e0a11e7b4347dc") }}

    with grouped_expression as (
    select




( 1=1 and count(distinct mdic_bol_region_of_destination) >= 1 and count(distinct mdic_bol_region_of_destination) <= 10
)
 as expression


    from "memory"."main"."brazil_mdic_port_2024"


),
validation_errors as (

    select
        *
    from
        grouped_expression
    where
        not(expression = true)

)

select *
from validation_errors