Amazon Redshift Connector - Error message

[LaurentACQ]

We connected a data source through Amazon Redshift Connector (by Google) on Looker Studio. However not all the charts would load and we have different types of error on the same page:

Unable to connect to Host: An I/O error occurred while sending to the backend.

Failed to execute connection with error: ERROR: Query cancelled on user's request

Failed to execute connection with error: Exception retrieving query results.

Would anyone know where it could come from?

[Lobo-Google]

Hi @LaurentACQ, thanks for your post! 

A good first step that I can recommend is taking a look through the Looker Studio Troubleshooting guide, which has some best practices about troubleshooting through various issues, including connection errors. It also has instructions about how to report a problem to Google for the team to investigate.

Looking through Stack Overflow, the I/O error message seems to be related to some networking connectivity issues that might be helpful to investigate. The Query cancelled on user's request error also seems to be related to timeout settings on the database. The third error message, Exception retrieving query results, is a little more elusive - this similar Community post has a solution that might be worth looking at,  and I also found another related Community post with an accepted solution.

The Amazon Redshift documentation also has some good information about what to troubleshoot for to resolve connection issues.

[Bhagyashri]

I am facing Exactly same issue. Did you gent solution for this?

[mattseaborn]

Yes, am getting the same issue intermittently, in my case with Redshift Serverless

Have been checking SYS_QUERY_HISTORY in Redshift and there are no obvious failures. The statement_timeout is currently set to zero (i.e. disabled).

Is there anyway to diagnose this?

[ricardo-milo]

Same error here randomly every day. Anyone find a solution?

[LaurentACQ]

We could not find a solution, so we switched to BigQuery.