In Snowflake there are useful commands like SHOW USERS (shows the users in your environment) or SHOW GRANTS TO ROLE (shows the privileges given to a certain role).
The results of these commands are shown like tables however, you cannot filter them like SHOW USERS WHERE …
You can however use the commands TABLE and RESULT_SCAN to query the results of the commands listed above as a table. Here is how it would look like:
show users
;
–Copy the query ID
select
*
from table( result_scan( paste_the_query_id ) )
— from table(result_scan(last_query_id())) –Or use this to use the latest query ID ;