Stable PostgreSQL Index

Hey y’all,

I am running dbt with a Postgres connector.

And in my local and CI environments, I get different index names.

I was wondering what goes into the index name calculation. I seem to have checked every suspect, such as target name, database name, etc… Yet, the index names still change.

I am doing a full snapshot test of the entire dbt-produced database.

Here’s a brief diff in the resulting schema between my local and CI envs: