5

I'm looking to allow connections from AWS Quicksight to my PostgreSQL database.

And in their FAQ they offer some advice that Quicksight has a dedicated IP range

Q: How do I connect my VPC to Amazon QuickSight?

If your VPC has been set up with public connectivity, 
you can add Amazon QuickSight’s IP address range to your database 
instances’ security group rules to enable traffic flow into your VPC 
and database instances.

But in the AWS IP Ranges JSON file (https://ip-ranges.amazonaws.com/ip-ranges.json) there is no mention of the AWS Quicksight range.

Simon
  • 153
  • 1
  • 5

2 Answers2

5

QuickSight's IP address ranges are as follow:

Region- IP Range

US East (N. Virginia) (us-east-1)- 52.23.63.224/27

US West (Oregon) (us-west-2)- 54.70.204.128/27

EU (Ireland) (eu-west-1)- 52.210.255.224/27

We're in the process of adding it to the ip-ranges.json file.

Thanks,

Luis

Luis Wang
  • 66
  • 1
  • 1
    I'm trying to connect to a MS SQL 2016 instance inside a VPC from quick sight as well. I've opened the `1433` port to all _any_ IP in the windows firewall. Then opened the 1433 port to the range Luis gave for `eu-west-1` in the security group but I still can't connect. BTW when I open the 1433 port to any IP I still can't connect from quick sight. I'm trying to connect to the server using its pubic IP. Could I be overlooking the obvious? – bounav Nov 16 '16 at 23:03
  • Hi bounav, there is a known issue with connecting to SQL server that is currently being fixed. I expect we will be able to deploy a fix in the next day or two. – Luis Wang Nov 16 '16 at 23:46
  • @LuisWang The connectivity issue only applies to MySQL? I am having problem connecting to PostgresRDS instance. All I get is non-descriptive error message `Connection failed, check connection information` – Roman Nov 17 '16 at 13:25
1

AWS published the IP ranges here: https://docs.aws.amazon.com/quicksight/latest/user/regions.html

perelin
  • 171
  • 1
  • 8