Problem with SHOW GROUPS command

[eballinger]

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

[SP_6721 · Accepted solution]

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.

[eballinger]

Thanks SP_6721, That was exactly my issue. all good now. 

Have a good day