Skip to content

is this possible to connect Quick sight with Redshift serverless?

0

i did follow the post "https://repost.aws/en/knowledge-center/quicksight-redshift-private-connection" this has details about the provisioned cluster. Able to setup the VPC connection the quick sight console but cant provide the details need to create "New Redshift Data store"

2 Answers
1

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

AWS
EXPERT
answered 2 years ago
EXPERT
reviewed 2 years ago
0

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:

EXPERT
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.