-
-
Notifications
You must be signed in to change notification settings - Fork 117
/
expect_table_row_count_to_equal.sql
29 lines (26 loc) · 1.12 KB
/
expect_table_row_count_to_equal.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
{%- test expect_table_row_count_to_equal(model,
value,
group_by=None,
row_condition=None
) -%}
{{ adapter.dispatch('test_expect_table_row_count_to_equal',
'dbt_expectations') (model,
value,
group_by,
row_condition
) }}
{% endtest %}
{%- macro default__test_expect_table_row_count_to_equal(model,
value,
group_by,
row_condition
) -%}
{% set expression %}
count(*) = {{ value }}
{% endset %}
{{ dbt_expectations.expression_is_true(model,
expression=expression,
group_by_columns=group_by,
row_condition=row_condition)
}}
{%- endmacro -%}