Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
How can I make Amazon QuickSight access a private RDS instance without using a VPC connection, through a CloudFormation template?
I want to allow Amazon QuickSight to connect to a private RDS instance (which is not publicly accessible) without setting up a VPC connection between QuickSight and the RDS instance. Is it possible to achieve this using a CloudFormation template? If not, what is the recommended architecture to allow QuickSight to access private RDS data securely, and can this entire setup be automated using CFN?
- Language
- English
- Newest
- Most votes
- Most comments
Hello.
To connect to an RDS deployed in a private subnet from QuickSight, you need to connect to a VPC as described in the following document.
https://repost.aws/knowledge-center/quicksight-redshift-private-connection
I haven't tried it using CloudFormation, but it looks like you can set up a connection to RDS using "AWS::QuickSight::DataSource" and "AWS::QuickSight::VPCConnection".
https://docs.aws.amazon.com/ja_jp/AWSCloudFormation/latest/TemplateReference/aws-resource-quicksight-datasource.html
https://docs.aws.amazon.com/ja_jp/AWSCloudFormation/latest/TemplateReference/aws-resource-quicksight-vpcconnection.html
