Unable to retrieve catalog, schema, tables using JDBC endpoint of SQL Warehouse

fly_high_five
Contributor

Hi,

I am connecting to SQL Warehouse in UC using its JDBC endpoint via DBeaver. However, it doesn't list any catalogs, schemas and tables. I checked the permission of SQL WH by logging to ADB Workspace and queried the table (attached a dummy table example) using Warehouse compute. 

Since its unity catalog, so I tried same with All Purpose Cluster. With APC, I am able to see tables via ADB workspace as well as DBeaver.

Can someone please guide what's preventing access of Unity Catalog through JDBC endpoint of SQL WH using DBeaver?

fly_high_five_0-1764770250626.pngfly_high_five_1-1764770371607.png

fly_high_five_2-1764770788643.png 

@szymon_dybczak @WilliamRosa 

#warehouse #jdbc #dbeaver