Date Dimensions

claus · December 4, 2019, 3:05am

Very cool! Just wanted to mention this macro I added to the dbt-date package a few weeks ago that does some of that as well.

github.com

calogica/dbt-date/blob/master/macros/get_date_dimension.sql

{% macro get_date_dimension(start_date, end_date) %}
{{ adapter_macro('dbt_date.get_date_dimension', start_date, end_date) }}
{% endmacro %}

{% macro default__get_date_dimension(start_date, end_date) %}
with base_dates as (
    {{ dbt_date.get_base_dates(start_date, end_date) }}
),
dates_with_prior_year_dates as (
    select
        cast(d.date_day as date) as date_day,
        cast({{ dbt_utils.dateadd('year', -1 , 'd.date_day') }} as date) as prior_year_date_day,
        cast({{ dbt_utils.dateadd('day', -364 , 'd.date_day') }} as date) as prior_year_over_year_date_day
    from
    	base_dates d
)
select
    d.date_day,
    cast({{ dbt_utils.dateadd('day', -1 , 'd.date_day') }} as date) as prior_date_day,
    cast({{ dbt_utils.dateadd('day', 1 , 'd.date_day') }} as date) as next_date_day,

This file has been truncated. show original

Topic		Replies	Views
New Package: dbt-date Show and Tell jinja , date-and-time , packages	2	5024	October 11, 2019
Using variables inside the dbt_utils.date_spine macro Help dbt-utils , date-and-time , variables	9	8220	May 30, 2024
Building a Calendar Table using dbt Show and Tell date-and-time	0	14915	April 29, 2019
Date Time Issue in dbt Core with Macros Help jinja , snowflake , macros , dbt-core	2	943	December 19, 2023
Introducing sqlfmt, an auto-formatter for dbt SQL Show and Tell sqlfmt	22	19548	April 12, 2023

Date Dimensions

Related topics