incremental_model.sql

{{
    config(
        materialized='incremental',
        unique_key='id',
        indexes=[
            {'columns': ['id', 'name']},
        ]
    )
}}

select
    1 as id,
    'drew' as name,
    getdate() as dt

index.sql

-- macros/index.sql

{% macro default__get_create_index_sql(relation, index_dict) -%}
  {%- set index_config = adapter.parse_index(index_dict) -%}
  {%- set comma_separated_columns = ", ".join(index_config.columns) -%}
  {%- set index_name = index_config.render(relation) -%}

  {%- do log('Creating an index on ' ~ relation ~ ' [' ~ comma_separated_columns ~ ']!', info=true) -%}

  ALTER TABLE {{ relation }}
    ADD CONSTRAINT "unique_{{ index_name }}"
    UNIQUE ({{ comma_separated_columns }});
{%- endmacro %}

table_model.sql

{{
    config(
        materialized='table',
        indexes=[
            {'columns': ['id', 'name']},
        ]
    )
}}

select
    1 as id,
    'drew' as name