topic Re: Problem with SHOW GROUPS command in Data Engineering

Problem with SHOW GROUPS command

eballinger — Thu, 10 Jul 2025 15:12:34 GMT

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

Re: Problem with SHOW GROUPS command

SP_6721 — Fri, 11 Jul 2025 14:47:40 GMT

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.

Re: Problem with SHOW GROUPS command

eballinger — Fri, 11 Jul 2025 14:58:38 GMT

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

Have a good day