I am trying to set up a Database Query connector to retrieve data from a postgreSQL table. I have specified the JDBC connector string, provided the userid and password.
When I supply the SQL Query to retrieve the data from the table, a simple SELECT *, clicking the SAMPLE button in that screen always fails with relation not found.
When I try to run the job, same issue "Relation not found"
I can copy paste the query from Matillion into PgAdmin and it works just fine.
In some cases, the database might be misconfigured or corrupted, leading to issues with table access. Check the database logs or consult with your database administrator to investigate further. Please check it .
Turned out that I had misunderstood the connectivity. I was using localhost to try and connect from Matillion since the PostGreSQL database was on my laptop. But localhost in Matillion refers to the aws instance on which Matillion is running, right! So I needed to explicitly point to my laptop- but that turned out to be another issue since we are not allowed outbound connections from aws w/o jumping thru a lot of hoops. So I gave up on that experiment. Thanks for looking in on me though