Need Help - System tables that contains all databricks users, service principal details !!

[Sanjeeb2024]

Hi all - I am trying to create a dashabord where I need to list down all users and service principals along with groups and understand their databricks usages. Is there any table available in Databricks that contains user, service principal details. Please help me on this.

[Akash_Nimbalkar]

Hi Sanjeeb,
Please let me know what worked for you.

[dans-vander]

Hello @Sanjeeb2024 ,

Why do you need this to be done using system tables?

If you have Account Admin access, there is a REST API that allows you to list all users, groups, and service principals for the account:

https://docs.databricks.com/api/scim/v1/user
https://docs.databricks.com/api/scim/v1/service-principal
https://docs.databricks.com/api/scim/v1/group

You can extract this information through a job using a service principal with Account Admin privileges, load it into a DataFrame, and then generate your own tables.
Please check if this meets your needs.

Regards,

Danilo Van der Linden