How do I find out which Databricks groups I'm a member of?

Question

I'm trying to figure out if I'm a member of a specific group on Databricks using either the website or Databricks CLI.

I found a reference to managing groups via an account console, but this requires an admin account. I also found the Databricks groups CLI, but the documentation says you need an admin account to use the API.

Answer 1

(Answering my own question.) It turns out that the Databricks groups CLI documentation is incorrect and you can use it to view your own groups as a user without admin access.

The command is:

databricks groups list-parents --user-name <your-user-name>

However, I can't view parents of other users, and I can't access the other databricks groups commands without getting an error message about lacking valid scope.

Answer 2

You can run this command in the SQL Editor:

show groups with user `[email protected]`