-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathiso_week_start.sql
32 lines (25 loc) · 975 Bytes
/
iso_week_start.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
30
31
32
{%- macro iso_week_start(date=None, tz=None) -%}
{%- set dt = date if date else dbt_date.today(tz) -%}
{{ adapter.dispatch("iso_week_start", "dbt_date")(dt) }}
{%- endmacro -%}
{%- macro _iso_week_start(date, week_type) -%}
cast({{ dbt.date_trunc(week_type, date) }} as date)
{%- endmacro %}
{%- macro default__iso_week_start(date) -%}
{{ dbt_date._iso_week_start(date, "isoweek") }}
{%- endmacro %}
{%- macro snowflake__iso_week_start(date) -%}
{{ dbt_date._iso_week_start(date, "week") }}
{%- endmacro %}
{%- macro postgres__iso_week_start(date) -%}
{{ dbt_date._iso_week_start(date, "week") }}
{%- endmacro %}
{%- macro duckdb__iso_week_start(date) -%}
{{ return(dbt_date.postgres__iso_week_start(date)) }}
{%- endmacro %}
{%- macro spark__iso_week_start(date) -%}
{{ dbt_date._iso_week_start(date, "week") }}
{%- endmacro %}
{%- macro trino__iso_week_start(date) -%}
{{ dbt_date._iso_week_start(date, "week") }}
{%- endmacro %}