Snowflake Dormant Users: Find Accounts Nobody Uses (SQL)
Dormant Snowflake accounts keep their roles and warehouse access. Run these ACCOUNT_USAGE queries to find them, disable them safely and stop the drift.
Fintel Analytics blog
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
3 of 234 posts
Dormant Snowflake accounts keep their roles and warehouse access. Run these ACCOUNT_USAGE queries to find them, disable them safely and stop the drift.
Snowflake is phasing out password-only logins. Run two SQL queries to find every LEGACY_SERVICE user and password login in your account, then migrate them before pipelines break.
Too many people, and too many dbt jobs, run as ACCOUNTADMIN. Use these Snowflake queries to find them and fix it safely.