Skip to Content
avatar image
Former Member

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

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

test1.png (20.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 08, 2015 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded