I have a question regarding the Retool Database, I am trying to connect my Google Forms to the Retool Database with Make or Zapier. For this, I need to use PostgreSQL, but I don't know where to find the data to fill in to get the connection to the database. I tried it with a Connection string, but that doesn't work. Here is a screenshot of the things I need to fill in:
Great post! But where do you set sslmode when connecting a Retool DB to make?
This post was helpful for taking the connection string Retool provides and extracting the host, user, password etc. as demonstrated above, but my Retool connection string also has with it "?sslmode=require" at the end.
When I simply leave it out, Make explicitly tells me the connection is insecure and I need to add 'sslmode=require' (so it seems like it works but it does not actually connect to the DB).
Where I am struggling is finding where to add it. Like in the example above, there is no field available for setting sslmode, and it does not work if you add it to the host, database, or user fields.
Hey @Shiva! Neon, the provider we use for RetoolDB has a workaround for that error in their docs here. It's also in the link they share with that error in Zapier.
Essentially passing the endpoint along with the password in the password field like this: endpoint=[endpointID]$[password]
The Zapier connection also has a dropdown to enforce encryption, but say it's a deprecated field for any connection created after NOV, 15 2023. Regardless, leaving it at True and passing the endpoint ID along with the password will allow you to connect.
@Raja_Rajcic I couldn't find any docs from Make on how to enforce ssl connections to the postgres db. You'll likely need to reach out to them to see how / if this is possible.
