@Marcelo Castro​ :

To show the groups that a user belongs to in Databricks using SQL, you can use the following query:

SELECT groupname FROM databricks_groups WHERE userid IN (SELECT userid FROM databricks_users WHERE username = 'user@domain.com')

This query uses the databricks_users and databricks_groups tables to get the userid associated with the username and then returns the group names associated with that userid. You can replace 'user@domain.com' with the username of the user you want to check. This should return the group names that the user belongs to.

Note that you will need the appropriate privileges to query the databricks_users and databricks_groups

tables.