Why did Heroku Connect create a unique index for one of my mapped columns?


You selected a field to be mapped within Heroku Connect, and Heroku Connect created a unique index for the associated column in Heroku Postgres.


Heroku Connect will automatically create indexes for the system columns for your mapped tables, such as id or sfid.

Besides these system fields, Unique External ID fields within Salesforce are expected to contain a unique identifier for each record that can be used by an external system, in place of a Salesforce ID when necessary.

Heroku Connect will automatically create a unique index in your Heroku Postgres database to ensure that the data will continue to be able to serve this purpose effectively.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support