Redshift connection issue

[arnaudshg]

Hi,

Since this morning we experiences connection issue between Looker Studio and Redshift with the following error message

Sorry, we encountered an error and were unable to complete your request.

Error ID: 35491014

The API call on https://lookerstudio.google.com/u/0/getAccountTree is in 403 with the response

{"reason":26,"errorStatus":{"reason":26,"code":7,"reasonStr":"JDBC_ACCESS_DENIED","errorCategoryStr":"ACCESS","category":1,"uniqueErrorCode":"35491014"},"params":{"errorId":"35491014"}}

On a dashboard we see this error

Unable to access table or database: FATAL: no pg_hba.conf entry for host "::ffff:142.251.74.0", 

Nothing change on our side between yesterday and today. We also already experience those errors randomly for one week now but now it's all the time.

Our redshift is publicly expose to the internet but with a security group that allow the IPs of your documentation https://support.google.com/looker-studio/answer/11377200#zippy=%2Cin-this-article

Thanks for your help

Arnaud.