expect_column_distinct_count_to_equal.sql

{% test expect_column_distinct_count_to_equal(model,
                                                    column_name,
                                                    value,
                                                    quote_values=False,
                                                    group_by=None,
                                                    row_condition=None
                                                    ) %}
{% set expression %}
count(distinct {{ column_name }}) = {{ value }}
{% endset %}
{{ dbt_expectations.expression_is_true(model,
                                        expression=expression,
                                        group_by_columns=group_by,
                                        row_condition=row_condition)
                                        }}
{%- endtest -%}