connect google spreadsheet to amazon redshift with jdbc mysql vs postgresql -

• i have amazon redshift db supports connecting postgresql client jdbc

• google apps scripts support connecting db jdbc, mysql, ms sql, , oracle protocol, not postgresql. if try, not surprisingly error:

'connection url uses unsupported jdbc protocol.'

looking @ google forums, has been issue several years no response google.

is there workaround?

thanks

if using amazon redshift can connect through amazon redshift client

here steps:

1. write sql query in redshift client , save report
2. use api key generated , report no. in embedded link.
3. use importdata function google spreadsheet import data automatically. refresh default every 1 hour.

thanks