It would be great to be able to pass response objects which will cause the dashboard to show the sync status as FAILED as well as some relevant error information.
We have a few Cloud Function connectors currently set up in Fivetran so having to use external monitoring, e.g. Google Cloud Function Alerts, would make the process quite cumbersome and would detract from the appeal of using Fivetran for such connectors.
Ideally, we could return a JSON object which is explicitly defined as an error, with some information.
For example, if the credentials don't have sufficient access for some parts of the Cloud Function execution it would be good to be able to trigger a FAILED sync, with some info such as: "4XX error: unauthorized credentials."
Perhaps you could add some optional objects to the response object, e.g. :
- sync_status which defaults to SUCCESS but can be set to FAILED explicitly
- sync_info which can have a text in it for passing error codes/descriptions/etc.