Heroku Connect Reuse Existing Schema

[mdanku]

Required Terms

• I agree to follow this project's Code of Conduct
• I have read and accept the Salesforce Program Agreement

What service(s) is this request for?

Postgres, Connect

Tell us about what you're trying to solve. What challenges are you facing?

Currently, Heroku Connect requires the dropping or renaming of an existing Postgres schema in order to recreate the Connect instance. This can be a problem if you have views in other schemas that reference tables in the Heroku Connect schema. It would be great if there could be more of an "in-place" approach to recreating Connect instances, where the schema and tables can be reused. Alternatively, it would be helpful if Connect instances did not need to be recreated for cases of a Salesforce sandbox refresh or change to the API version.

[vivekvj01]

Thank you for bringing this up @mdanku. This seems like a frustrating situation. Let us look into this.