data-dwh-dbt-project/macros/tests/is_last_day_of_month.sql
2024-12-18 10:52:52 +01:00

10 lines
266 B
SQL

{% test is_last_day_of_month(model, column_name) %}
select *
from {{ model }}
where
{{ column_name }} != (
date_trunc('MONTH', {{ column_name }})
+ interval '1 MONTH'
- interval '1 DAY'
)
{% endtest %}