How can I connect Google Looker Studio with AWS Redshift?
I am trying to connect Looker Studio with Amazon Redshift but keep getting this error
I had to make sure everything related to connection details was the same and also tried to connect with Basic and JDBC methods but got the same error.
I read a few links as well regarding this but wasn't able to make it work, also Error message is kind of generic We encountered an error... don't even tell what could be the root cause.
According to this, I tried to enable SSL and uploaded the pem file.
Downloaded the .crt file from the above link converted the file extension to .pem then attached it but the same issue.
If anyone from the Looker Studio community has faced this issue, please let me know.
References:
found a solution myself, here's the guide:
Download SSL certificate from here: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-ssl-support.html
- This is the URL: https://s3.amazonaws.com/redshift-downloads/amazon-trust-ca-bundle.crt
- It will download
amazon-trust-ca-bundle.crton your PC - rename the file to
amazon-trust-ca-bundle.pem
Make sure it's publicly accessible (Amazon Redshift Serverless > Workgroup configuration > <your-wrokgroup>)
- Add this rule to your Security Group (Amazon Redshift Serverless > Workgroup configuration > <your-wrokgroup> > VPC security group)
- Then once all of the above step is completed try to Authenticate again
This guy is amazing his video also helped me along: https://www.youtube.com/watch?v=22K0PxjwIa0
- Redshift COPY query hangs. (Running but not submitted) (Table size just 30 rows)
- ERROR: permission denied for relation stl_query, how to resolve?
- How can I connect Google Looker Studio with AWS Redshift?
- Json parsing errors while using json_extract_path_text() function in where clause
- Redshift SUPER type: accessing camel case fields returning null result
- JSON stored in SUPER type fails to select camelcase element. Too long to be serialized. How can I select?
- How to Extract Nested JSON Array in Redshift and Create a Table with Specific Columns?
- Query permissions for a specific table in redshift (Groups and Users)
- Carrying forward SQL
- How to count from 0 and onward for every new ID?
- "SQL Error [XX000]: ERROR: Numeric column 2 precision and scales cannot be merged" when coding logic in REdhsift
- Explode values in dbt
- How to query last Saturday and the one before in SQL?
- Insert missing rows in time series consumption history
- Translate excel formulas into Redshift SQL query
- Proper syntax in redshift sql for "schema"."table"."field"?
- Redshift ERROR: relation "Temp table" does not exist
- Error copying parquet file to Redshift having comma separated data in one column
- Unnest an array in AWS Redshift
- Where can I find usage statistics in Redshift?
- How to write more than 25 items/rows into Table for DynamoDB?
- The difference between text255 and bytedict Redshift encodings
- JSON Redshift SQL - Iterate through array of json
- Move data from one table to another with Redshift
- How to Resolve 'Invalid JSONPath Format' Error When Importing Nested JSON into Amazon Redshift?
- Json Extract from column in amazon redshift
- How to duplicate a Redshift table schema?
- Google Apps Script connection to AWS Redshift Data API with AWS Signature V4
- How can I differentiate between null value and empty string in query result?
- How to add multiple columns in AWS redshift with alter table query