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

[fly_high_five]

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?

 

@szymon_dybczak @WilliamRosa 

#warehouse #jdbc #dbeaver

[mitchellg-db]

Hi there,

I'm not familiar with DBeaver specifically, but I have experienced DBSQL Warehouses being much stricter when enforcing permissions than All-Purpose Clusters. Warehouses check explicitly if that identity has access to those assets, where All-Purpose Clusters may have several different configurations that makes them appear more permissive. You cannot rely on admin permissions when using a warehouse either.

I know it sounds silly as you can literally see the tables using the warehouse in the Databricks GUI, but I'd still double check that your user, or the service principal you are using for the JDBC connection, has the following permissions on the Catalog/Schemas that you wish to see:

GRANT USE CATALOG ON CATALOG <catalog> TO <principal>;
GRANT USE SCHEMA  ON SCHEMA  <catalog>.<schema> TO <principal>;

Let us know if you figure it out!