CODEWITHSUNDEEP
postgresqlgoogle-cloud-platformlooker-studio
nate fishel
nate fishel

Reputation: 69

How to connect Postgres DB to Google Data Studio

I have a cloud based Postgres DB that I want to connect to Google Data Studio, both are part of the same GC project. When I try to use the built in connector for postgres through Data Studio I receive error Error ID: ff6a9ba9. I know my DB is working because I can connect to it outside of Data Studio

I tried using the same Postgres public IP that I can connect to from my local machine but I had to whitelist that. The problem with connecting Data Studio is I don't know the IP address of that server, so I can't whitelist it. Is there a different type of connection to use within the same GCP Project (sort of how App Engine also requires the "Connection Name")?

Upvotes: 3

Views: 5128

Answers (1)

P_impl55
P_impl55

Reputation: 148

Be sure to whitelist the following IP ranges listed under the NOTES section of this help document for Data Studio + Postgres connections: https://support.google.com/datastudio/answer/7288010?hl=en

Upvotes: 1

Related Questions