I am trying to create an account to connect to a Postgres db and continue to get a "Failed to validate account" error.
- I have tried both setting up with type Postgres Account and Postgres Dynamic Account.
- I have downloaded and added the most recent JDBC driver
- I have added sslmode of require in the URL properties, as noted in the documentation
In speaking with the technical resource for the database who looked at the logs while I tried to connect, he was seeing that SnapLogic wasn't passing through the username and database, so it was timing out due to that. The username and database are filled in in the account properties. They work to connect to the database via a different software, so we know they are valid.