expect_column_values_to_be_null.sql

{% macro test_expect_column_values_to_be_null(model, column_name,
                                                partition_column=None,
                                                partition_filter=None
                                                ) %}

{% set filter_cond = partition_column ~ " " ~ partition_filter if partition_column and partition_filter else None %}
{% set expression = column_name ~ " is null" %}

{{ dbt_expectations.expression_is_true(model, 
                                        expression=expression,
                                        filter_cond=filter_cond
                                        )
                                        }}
{% endmacro %}