Databricks SQL supports the SHOW GROUPS command to list all groups within a system. This command optionally allows filtering by specific user associations or regular expressions to identify desired groups.
The statement syntax is:
SHOW GROUPS [ WITH USER user_principal | WITH GROUP group_principal ] [ [ LIKE ] regex_pattern ];
This can be used to fetch specific groups associated with users. The output provides columns like name (group name) and directGroup (membership type: direct/indirect or NULL if no principal is specified)
