Connect google spreadsheet to amazon redshift amazon using jdbc mysql vs postgresql

Question

• I have a reddash db amazon that supports connecting a postgresql client using jdbc

• The google apps scripts support connecting to db with jdbc, but only with mysql, ms sql and oracle protocol, but not postgresql. If I try, it is not surprising that I get an error:

'The connection URL uses an unsupported JDBC protocol.'

Looking at some google forums, this has been a problem for several years with no response from google.

Is there a workaround?

thanks

Answer 1

If you are using Amazon redshift, you can connect it through the redshift amazon client

Here are the steps:

• Write an SQL query in the redshift client and save it as a report
• use your generated api key and report no. in the inline link.
• use the importdata function for google spreadsheet to automatically import data. it will be updated by default every one hour.

thanks

Answer 2

I use Kloudio, the Google Sheets extension, to do this. I can run and schedule my redshift requests in Kloudio