I've been trying to check, via databricks SQL, which groups a user belongs to.
When I run SHOW GROUPS or SHOW USERS, everything is returned correctly.
However, when a try to run:
SHOW GROUPS WITH USER `user@domain.com`
Nothing is returned, but the user belongs to one of the existing groups.
What is the right way to execute this query and get the expected results?