Redshift conenction with JDBC connection string

Get Help
1

Hi,

My goal is to connect with a Redshift database that needs IPs to be whitelisted.

I'm hosting Metabase on Heroku, so I enabled QuotaGuard Static IP. Assuming I can use the host, password, username in the additional JDBC connection options so that it routes through the proxy.

My issue is that I don't know what format the JDBC connection string is expecting.. The docs just mention that you can add the options but there's no example.

Thanks

2

sorry, I don't get this: if heroku gives you a static ip then you should go to redshift and put the static ip there

regards,
Luis