{{
    config(
        materialized="table",
        post_hook=" drop table {{ this }}; " 
    )
}}

-------- ADD BACKFILLS HERE --------
{% set backfill_list = {
		'my_table_name' : 'primary_key_id_column_name',
		'another_table_name' : 'another_primary_key_id_column_name',
    }
%}

{% if backfill_list|length > 0 %}
{% for mod in backfill_list %}
    {% set bf = mod~'_backfill_apply' %}
    -- depends_on: {{ ref(mod) }}
    -- depends_on: {{ ref(bf) }}
    {{ run_query('apply_snapshot_backfill(ref(mod), ref(bf), backfill_list[mod] )')  }}
    {%- if not loop.last -%} union all {% endif -%}      
{%- endfor -%}
{% else %} 
select 1
{% endif -%}