The database connection works, but when trying to access the table, the following error appears.
An error occurred and we were unable to complete your request
Error IDs:
2a625dad
fedc4935
8f6114b9
59e3ea2f
Hey!
The error message you’re seeing, “An error occurred and we were unable to complete your request,” is a generic error in Looker Studio that can be caused by various issues when connecting to an AWS Redshift database.
Maybe the Looker service account that you are using does not have the necessary permissions to access your Redshift database and the specific tables you want to query. Or maybe the Redshift user needs the appropriate permissions on the database and tables.