How to make sql evaluate character @ in show command in snowflake

Question

I am trying to run the query in snowflake

show grants to user username

ex: show grants to user test_account

It works if I give username as test_account but if i change it to use something like eax@org.net. It fails because of @ character.

How can I make it evaluate @ character?

user_43992 · Answer

the same way as you created them, with double quotes:

create user "test@account";

show grants to user "test@account";