This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Connecting to Postgres

Posted on 11-14-2024 04:45 AM
tashfeenekram
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I am trying to connect to a postgres database hosted on AWS. 

I am getting this cryptic error message:

Error ID: 73baa6d0

Appreciate deciphering this. 

0 4 211
Topic Labels
0 Likes
Reply
4 REPLIES 4

Posted on --/--/---- --:-- AM
tashfeenekram
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Any help on this?

0 Likes
Reply

Posted on --/--/---- --:-- AM
dylantrose
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Post the structure of the dataset you're connecting including columns and datatypes. I saw you posted on another post that included some solutions, but I'll restate what I'd try.

1. Ensure that your columns do not contain capitals or weird characters. I would recommend using "column_name" rather than the common "columnName" as the capital will mess it up.

2. Ensure that you have added looker studio's IP to your whitelist in your postgres AWS database. Here is a link that gives instructions on this as well as the IP you should whitelist: link

Sincerely,

Dylan

Reply

Posted on --/--/---- --:-- AM
tashfeenekram
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

tashfeenekram_0-1732031896102.png

Here are the columns. 

Also, the link is open to the world. I can access it through command line and other desktop tools

0 Likes
Reply

Posted on --/--/---- --:-- AM
dylantrose
Silver 1
Silver 1
In response to tashfeenekram
Reply posted on --/--/---- --:-- AM

Is your AWS Postgresql through AWS RDS?

0 Likes
Reply