Comments on: How to connect Looker Studio to PostgreSQL (previously: Google Data Studio)

By: A 10-minute crash course on Google Data Studio

A 10-minute crash course on Google Data Studio — Mon, 19 Nov 2018 13:22:12 +0000

[…] 4. In this example, I’ve used Google Sheets, which is probably the easiest data source to start with, although feel free to connect to your MySQL or PostgreSQL databases. […]

By: Tomi Mester

Tomi Mester — Wed, 31 Oct 2018 14:12:48 +0000

In reply to Dennis Callejas.

hey Dennis,

I’m afraid I don’t know any good solution for that purely in SQL. (If someone does, please comment.)
I usually do it by using a bash for loop (or something similar)… but for that you need to learn a little bit of bash, too:
https://data36.com/learn-data-analytics-bash-scratch/

Cheers,
Tomi

By: Dennis Callejas

Dennis Callejas — Tue, 23 Oct 2018 11:39:08 +0000

How I could import more than one table? in my case I have many tables, I have to do it one by one? Thanks.

By: Tomi Mester

Tomi Mester — Tue, 31 Jul 2018 16:41:45 +0000

In reply to Eran.

hey Eran,

if you did everything like it was described (and I assume you did, since PgAdmin is working), then it might be a firewall issue.
Try to run SQL Workbench as administrator (if you are on windows), pause your firewall programs and/or whitelist SQL Workbench and your server’s IP and it should work!

Let me know wether this fixed the issue or not!

Cheers,
Tomi

By: Eran

Eran — Sun, 29 Jul 2018 18:57:58 +0000

Hi
I follow the procedure and provided the correct connection details. When I do Authenticate I get error:
Access denied, please check your username and password.

Error ID: c54492a4

I double checked the username and password on PGAdmin and the credential does work