table indexes (postgres)

indexes.sql

-- Macros to add indexes:

-- macros/indexes.sql
{% macro index(this, column) %}

drop index if exists "{{ this.schema }}"."{{ this.name }}__index_on_{{ column }}" cascade;
create index "{{ this.name }}__index_on_{{ column }}" on {{ this }} ("{{ column }}")

{% endmacro %}

{% macro unique_index(this, column) %}

drop index if exists "{{ this.schema }}"."{{ this.name }}__index_on_{{ column }}" cascade;
create unique index "{{ this.name }}__index_on_{{ column }}" on {{ this }} ("{{ column }}")

{% endmacro %}

-- Call them like this in your model code:
-- models/my_model.sql
{{
    config({
        "materialized": "table",
        "post-hook": [
            "{{ unique_index(this, 'id') }}",
        ],
    })
}}

...