Can't connect to RDS using QuickSight (execution role?)

Question

QuickSight is saying that it doesn’t have permissions to access that database so I went there to find the necessary permissions for it. I aligned the security groups correctly on the console but on "Manage VPC connections" inside QuickSight settings I can't manage to add a VPC connection because it's asking for a "execution role".

Where do I get this? Is that an IAM role? If so, I can't create a role for QuickSight

This image

Where do I get this? Is that an IAM role? If so, I can't create a role for QuickSight

![This image](/media/postImages/original/IMp7jrdddoRMGAe-8vZ5gf0A)

Accepted Answer

You will need to create a role for the QuickSight service to assume, below is more information regarding what the execution role is and guided instructions can be found [here](https://docs.aws.amazon.com/quicksight/latest/user/vpc-creating-a-connection-in-quicksight-console.html).

Execution role– An IAM role that contains a trust policy that allows QuickSight to create, update, and delete network infrastructure in your account. This policy is required for all VPC connections. At minimum, the IAM policy needs the following Amazon EC2 permissions:

DescribeSecurityGroups

DescribeSubnets

CreateNetworkInterface

DeleteNetworkInterface

ModifyNetworkInterfaceAttribute

Can't connect to RDS using QuickSight (execution role?)

Relevant content