expect_column_proportion_of_unique_values_to_be_between.sql

{% macro test_expect_column_proportion_of_unique_values_to_be_between(model, column_name,
                                                            minimum,
                                                            maximum,
                                                            partition_column=None,
                                                            partition_filter=None
                                                            ) %}
{% set expression %}
count(distinct {{ column_name }})/count({{ column_name }})
{% endset %}
{{ dbt_expectations.expression_between(model, 
                                        expression=expression,
                                        minimum=minimum, 
                                        maximum=maximum, 
                                        partition_column=partition_column, 
                                        partition_filter=partition_filter
                                        ) }}

{% endmacro %}