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
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 198
Topic Labels
0 Likes
4 REPLIES 4

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

Any help on this?

0 Likes

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

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

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