DWC OpenSQL access via JDBC Tools (e.g. DBeaver and SQuirrelSQL)
I am trying to use DBeaver jdbctool to access my DWC Space/Schema. I can connect with DBeaver but the tables I created via the DWC Data Builder UI do not appear in the DBeaver.
NOTE 1): I can see 2 schemas when I connect with DBeaver. The first is the schema: INSPIRED_INTELLECT#INSPIRED_INTELLECT but as I said before it is empty. However there is a second schema called SYS that contains a single table called DUMMY with a single CHAR(1) column called DUMMY and a single row/value = "X". I can see these in DBeaver.
NOTE 2): I also tried a second JDBC tool called SQuirrelSQL. same result as DBeaver.
Maybe, there is some kind of table access privilege that needs to be granted?
The connection is as follows:
JDBC driver: HANA
user id: INSPIRED_INTELLECT#INSPIRED_INTELLECT
other driver properties: