- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2025 08:12 AM
We have 3 environments (dev, qc and prod). In DEV and QC I can issue this command:
SHOW GROUPS
from a sql notebook and it will show the group I have created for each workspace. However in production this group is not displayed. This group in all 3 cases from from MIcrosoft Entra Id and even in production the group that is missing has permissions applied to different catalogs and schemas.
We can see the group fine when we look under the groups from the "Manage Account" interface. I realize that SHOW GROUPS would only show groups applied to the workspace (not account level like manage account). But we have this missing group applied in prod and its not showing in the list.
Is there a bug with this? Has anyone else encountered this issue of missing groups from this command.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2025 07:47 AM
Hi @eballinger ,
It’s likely that in your prod environment, the group isn’t explicitly assigned to the workspace, even if it has permissions on catalogs or appears in the account console.
Try assigning the group directly to the PROD workspace through the Databricks account console.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2025 07:58 AM
Thanks SP_6721, That was exactly my issue. all good now.
Have a good day