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

DBT test name: dbt_expectations_expect_column_unique_value_count_to_be_between_brazil_bol_2025_gold_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/bol/_schema_brazil_bol.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• brazil_bol_2025_gold

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

    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_bol_2025_gold"


),
validation_errors as (

    select
        *
    from
        grouped_expression
    where
        not(expression = true)

)

select *
from validation_errors