Data Studio
3.7K members online now
3.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

AWS Aurora: Data Studio randomly shows connection errors

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Issue: data studio randomly shows connection errors for some of widgets on the page.

It is not a consistent behavior, other widgets are failing upon page refresh. Sometimes all widgets are working, sometimes all are failing

The data source is a really small static table with like 7 columns. No data changing there.

 

random-errors.jpg

 

 

Aurora has the following IP ranges white-listed (via security group):

 

MYSQL/Aurora
TCP
3306
64.18.0.0/20
MYSQL/Aurora
TCP
3306
64.233.160.0/19
MYSQL/Aurora
TCP
3306
66.102.0.0/20
MYSQL/Aurora
TCP
3306
66.249.80.0/20
MYSQL/Aurora
TCP
3306
72.14.192.0/18
MYSQL/Aurora
TCP
3306
74.125.0.0/16
MYSQL/Aurora
TCP
3306
108.177.8.0/21
MYSQL/Aurora
TCP
3306
173.194.0.0/16
MYSQL/Aurora
TCP
3306
207.126.144.0/20
MYSQL/Aurora
TCP
3306
209.85.128.0/17
MYSQL/Aurora
TCP
3306
216.58.192.0/19
MYSQL/Aurora
TCP
3306
216.239.32.0/19

 

Does that mean that IP list above is not complete?

Looks to be inline with: https://support.google.com/datastudio/answer/7088031?hl=en&ref_topic=6370347