Error setting up Snowflake to PostgreSQL connection via Airbyte using Terraform


Error message ‘ERROR: permission denied for database postgres’ when syncing connection in Airbyte UI


I am trying to setup the connection from Snowflake to PostgreSQL, via Airbyte. In this connection, I am supposed to set this connection for various environments in AWS, and so am setting up this connection of Airbyte using Terraform.
I have implemented the logic for the same, and tried to test it on the Airbyte UI, but in Airbyte UI when I am trying to sync the connection, am facing the error.
Error message states: Failure Origin: destination, Message: State code: 42501; Message: ERROR: permission denied for database postgres
Can anyone please help me understand what this error is all about and how to resolve it?

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["snowflake", "postgresql", "airbyte", "terraform", "connection-error"]