© 2026 LinearBytes Inc.
Search posts, tags, users, and pages
Serge Shakhov
Hi John, What is MONITOR_GRANT_TO_ROLES? It doesn't exist in my Snowflake databases.
John Ryan
Drawing Pictures, Telling Stories, Explaining Stuff
Hey Serge. Really sorry for the typo, I normally create a local temporary table to avoid re-querying the ACCOUNT_USAGE views.
Now amended (and TESTED!) the query.
Thanks for pointing that out. Hope it's useful to you now!