stg_date_dimension.sql

{%- call statement('date_range_query', fetch_result=True) -%}
    select
        min(order_date) min_date,
        max(order_date) max_date
    from {{ ref('stg_sales_data') }}
{%- endcall -%}

{%- set start_date = load_result('date_range_query')['data'][0][0] -%}
{%- set end_date = load_result('date_range_query')['data'][0][1] -%}

{{ dbt_date.get_date_dimension(start_date, end_date) }}