Add support for constants

[GuillermoNasarre]

Context

In my organization, we share a common package with reusable and standardized logic.

In this package, we centralize variables like:

• tracking_start_date
• desktop_id

Since these variables should never change, we came up with this approach:

1. Write a constants macro in the package:

{% macro constants() -%}

    {%- set constants = namespace() -%}
    
    {%- set constants.TRACKING_START_DATE = "date(2025, 1, 1)" -%}

    {%- set constants.DEVICE_IDS = namespace(
        DESKTOP=1234,
        MOBILE=4321
    ) -%}
    
    {%- do return(constants) -%}
    
{%- endmacro %}

2. Call the constants macro from the project:

select * from `table` where device_id = {{ package.constants().DEVICE_IDS.DESKTOP }}

Idea

What do you think of adding support for constants?

# dbt_project.yml
constants:
   TRACKING_START_DATE: date(2025, 1, 1)

-- vars-like approach
{{ constant("TRACKING_START_DATE") }}

-- namespace approach (enables accessing package constants)
{{ package.constants.TRACKING_START_DATE }}