Can PostgreSQL on Cloud SQL Private Connection be established with Looker Studio Pro?

Can PostgreSQL on Cloud SQL Private Connection be established with Looker Studio Pro?

Solved Solved
0 1 570
1 ACCEPTED SOLUTION

Looker Studio doesn't support private IP connections to PostgreSQL on Cloud SQL.

Potential Workaround Tested: Enabling a Public IP with Authorized Network Access: This workaround assigns a public IP to PostgreSQL but restricts access to specific IP ranges, including LSP’s range (142.251.74.0/23).

Note: This solution may not be ideal for many customers who prefer not to expose their databases via a public IP, even with restricted access.


.

View solution in original post

1 REPLY 1

Looker Studio doesn't support private IP connections to PostgreSQL on Cloud SQL.

Potential Workaround Tested: Enabling a Public IP with Authorized Network Access: This workaround assigns a public IP to PostgreSQL but restricts access to specific IP ranges, including LSP’s range (142.251.74.0/23).

Note: This solution may not be ideal for many customers who prefer not to expose their databases via a public IP, even with restricted access.


.