Heroku Connect Error: Foreign Key Relationships not supported in Bulk Query

Issue

You have a connection syncing with a Salesforce sandbox org and are now seeing the following error in your Heroku Connect dashboard logs:

FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in Bulk Query

Resolution

Heroku Connect relies on this feature. It is enabled by default in production orgs but not in sandbox orgs. In order to have this feature enabled for your sandbox org, you must contact Salesforce support.