- Newest
- Most votes
- Most comments
Yes. You can connect to Redshift serverless using QuickSight. Please follow below instructions under "Manually enabling access to an Amazon Redshift cluster in a VPC"
https://docs.aws.amazon.com/quicksight/latest/user/enabling-access-redshift.html#redshift-vpc-access
Yes, it's possible to connect Amazon QuickSight with Amazon Redshift Serverless. Here are the steps you can follow to set up this connection:
1. Set Up Your Redshift Serverless Endpoint Ensure your Amazon Redshift Serverless endpoint is correctly set up and accessible from your Amazon QuickSight environment.
2. VPC Connection Create a VPC Connection: In the QuickSight console, create a VPC connection to your Redshift Serverless endpoint. Security Groups and Subnets: Ensure the security groups and subnets allow traffic between QuickSight and Redshift Serverless.
3. Create a New Redshift Data Store in QuickSight
Sign in to Amazon QuickSight:
Open the QuickSight console. Manage Data:
Go to Manage Data from the QuickSight dashboard. New Data Set:
Click on New data set.
Select Redshift:
Choose Redshift as the data source. Create a New Redshift Data Store:
Data source name: Give your data source a name. Cluster ID: Use the endpoint URL of your Redshift Serverless. Database name: Provide the name of your database in Redshift Serverless. Database user: Enter the database user credentials. Password: Enter the database password.
VPC Connection:
Select the VPC connection you created earlier.
Test Connection:
Click on Test Connection to ensure everything is set up correctly.
Create Data Source:
Once the connection is successful, click Create data source.
Choose Tables:
Select the tables you want to visualize and then create the data set. Troubleshooting Tips:
Relevant content
- asked 4 years ago
