How can I get workspace groups and their users via a table — and also from a Databricks App?

discuss_darende
New Contributor III

‎01-26-2026 01:27 AM

I’m trying to get a full list of Databricks workspace groups and their user memberships. I want to do this in two ways:

  1. As a queryable table or view (e.g., for audits, security reviews, app integration)

  2. From within a Databricks App (Streamlit-style), using Python (SDK or SQL)

    I see information about system.access.users table but can't see the table, if it's not enabled in the system is it possible to enable later or what other options do I have to get the group.

 

To be more spesific as an admin when I create a group in workspace such as 'project-users' assign that group user1@email.com and give read access to that group. I want to be able to get the information as a table instead of checking the databricks UI.

0 Kudos