postgreSQL connection in IDT: Queries always throw Error: schema XXX does not exist

[Former Member]

Hi,

I created a small database with one table and 3 columns. First name, last name and age. There are 3 rows.I can see all the data correctly in pgAdmin,

I can then successfully create this connection in IDT and create a simple data foundation with the one table. I can see the metadata and it shows me the three columns.

BOBJ_Local

-> BOBJ_Test

     ->Test_Table

          - First Name

          - Last Name

          - Age

However when I try to view the data I get an error;

Error occurred in refresh

ERROR: schema "bobj_test" does not exist;

No query has been executed with that handle

When expanding more Details;

Error:

Failed to execute; SELECT BOBJ_Test.Test_Table."First Name", BOBJ_Test.Test_Table."Last Name", BOBJ_Test.Test_Table."Age"FROM BOBJ_Test.Test_table

Cause of Error

ERROR: schema "bobj_test" does not exist;

No query has been executed with that handle

I have attached a screenshot of the data foundation;

Any help would be appreciated

Thanks

Ali

[amitrathi239]

Hi,

Try after refresh the structure in data foundation layer and see.

also connection you have created with "Bobj_test" user and some different user?

Amit