Connector Improvement: Allow disabling or self-management of heartbeat function for Aurora Postgres connector
For this functionality, https://fivetran.com/docs/databases/postgresql#heartbeat the fivetran db user needs access to create and drop for our schema in postgres. We don't want to give such broad permissions to fivetran. We would much rather be able to either disable this functionality or create the heartbeat function ourselves in the database instead of giving fivetran the ability to manage it.
Since we haven't given these permissions, fivetran is flooding our db logs which is causing difficulties.
-
Official comment
Hi all,
Thank you for your feedback on this post. We introduced the heartbeat mechanism to help with Postgres connector stability and monitoring several years ago.
Since then, we have made substantial improvements to the performance, reliability, and functionality of the Postgres connector.
We have determined this heartbeat mechanism is no longer necessary, and we will be removing this heartbeat from the connector.
Thank you for all your feedback! Please let me know if you have any questions.
-
Create and Drop permissions will never be granted to this read only user.
If you provide me with the function definitions, I can create the functions and grant execute on these functions to the user login we use for Fivetran
Please sign in to leave a comment.
Comments
2 comments