Macro required arguments

ckchow · November 17, 2022, 9:05pm

Is there a clean way to require the existence / nonnull-ness of an argument to a macro?

joellabes · November 25, 2022, 2:50am

Wonderful question! Right now the answer is no, but I’d love it if you could go and weigh in on this issue: [CT-459] [Feature] Extend Jinja macros to contain required arguments (and maybe type hints) · Issue #4999 · dbt-labs/dbt-core · GitHub

In that issue, you can also see an example of how I’ve gone about this in the past:

github.com

dbt-labs/dbt_metrics/blob/39ebdaebc72ca80c7ecdbe5df5a0c08adbe5df6f/macros/secondary_calculations/secondary_calculation_period_over_period.sql#L36-L45


      
          {% set missing_args = [] %}
          {% if not comparison_strategy %}
              {% set _ = missing_args.append("comparison_strategy") %}
          {% endif %}
          {% if not interval %} 
              {% set _ = missing_args.append("interval") %}
          {% endif %}
          {% if missing_args | length > 0 %}
              {% do exceptions.raise_compiler_error( missing_args | join(", ") ~ ' not provided to period_over_period') %}
          {% endif %}

Topic		Replies	Views
basic macro question Help jinja	7	1173	January 4, 2024
dbt - snowflake - validate function Help jinja , snowflake , macro , macros , dbt-core	0	939	August 19, 2023
Problem with Jinja macro if Help	1	1039	May 4, 2023
'None' has no attribute 'table' Help jinja , macros	3	7829	March 29, 2023
How would you validate macro input? Help jinja	4	3373	April 11, 2020

Macro required arguments

Related topics