palearnings
New Contributor III

Hi @szymon_dybczak  and @Raman_Unifeye ,
Thanks for answering my questions. I have granted the same permissions for both catalogues:

  • USE CATALOG
  • USE SCHEMA on the schemas under both catalogues
  • SELECT on the tables under both schemas and catalogues

I even granted ALL PRIVILEGES to my service principal and all account users for testing purposes. However, ADF is still unable to see the catalogue and its contents.

When I was checking that my service principal had the same privileges on both catalogues, I realised that the principal name on my default catalogue is _workspace_users_databricks_34xxx.
See the screenshot.

20251118_catalog_permissions.png
When I tried granting privileges to _workspace_users_databricks_34xxx, I received the following response:

[RequestId=f9efc352-a596-4197-aea1-debf36a1bdb8 ErrorClass=INVALID_PARAMETER_VALUE.UC_SYSTEM_WORKSPACE_GROUP_PERMISSION_UNSUPPORTED] Cannot grant privileges on CATALOG to system generated group _workspace_users_databricks_34xxx


Do you know what I might have missed?