expect_column_pair_values_A_to_be_greater_than_B.sql

{% test expect_column_pair_values_A_to_be_greater_than_B(model,
                                                                column_A,
                                                                column_B,
                                                                or_equal=False,
                                                                row_condition=None
                                                                ) %}

{% set operator = ">=" if or_equal else ">" %}
{% set expression = column_A ~ " " ~ operator ~ " " ~ column_B %}

{{ dbt_expectations.expression_is_true(model,
                                        expression=expression,
                                        group_by_columns=None,
                                        row_condition=row_condition
                                        )
                                        }}

{% endtest %}