Some operations, including Salesforce schema changes and API version upgrades, require Heroku Connect to get an updated copy of your Salesforce schema and apply appropriate changes to your Postgres database tables. In these cases, we typically ask customers to edit the mapping and save it again, without making any changes. But for customers with lots of mappings, perhaps across multiple connections, this can be very time-consuming.
An easy way to edit every mapping at once is to import a configuration file into your connection. You can export your existing configuration from the Manage Connection tab on your dashboard, then import that file back into your connection, without making any changes to it. This won't make any changes to your connection or reload any tables, but it will trigger a save on every mapping, which will kick off the necessary tasks to recover from the original changes that were made.
For customers with multiple connections, this process can also be performed using our CLI plugin.
$ heroku connect:export fetching configuration... done writing configuration to file... app-haiku-1234-herokuconnect-haiku-12345.json $ heroku connect:import app-haiku-1234-herokuconnect-haiku-12345.json uploading app-haiku-1234-herokuconnect-haiku-12345.json... done
This can then be easily scripted to apply to multiple environments using the
--resource arguments as well.