jinja2 - Using if block in dbt models

Question

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.

Answer 1

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 %}