pass a parameter to ref dbt jinja

user_18283242 0
Viewed 91

I have a macro. How can I pass correctly model name to a ref function ?

{% macro count_all_macro(model) %}


SELECT count(*) FROM {{ ref ( {{ model }} ) }}
{% endmacro %}
dbt jinja2 sql
1 Answers

I just needed to pass to a ref function without {{ }} SO it will look like

SELECT count(*) FROM {{ ref ( model ) }}

user_182832420
Related