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?