Search code examples
jinja2dbt

Using if block in dbt models

Apologies for asking dumb question. But I tried many different approaches but none of them seems to work.

I have a requirement to select data from 2 different tables based on the variable. I am trying to do that in dbt models with if statement but it doesn't seem to work.

Model looks something like thins:

SELECT 
*
FROM
{% if enable_whitelisting == 'true' %}
    {{ ref('accounts_whitelisted') }}    accounts
{% else %}
        {{ ref('accounts') }}   accounts
{% endif %}

Any help is appreciated.

Thanks in advance.

Solution

  • I got this working eventually. Have to put the variable name within the var()

    SELECT 
*
FROM
{% if var('enable_whitelisting') == 'true' %}
    {{ ref('accounts_whitelisted') }}    accounts
{% else %}
        {{ ref('accounts') }}   accounts
{% endif %}