Fintel Analytics blog

Data & AI Insights

Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.

3 of 234 posts

Data Engineering

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.

SnowflakeData GovernanceSnowflake Security
Data Engineering

Snowflake LEGACY_SERVICE Users: Find Password Logins Now

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.

SnowflakeSnowflake securitykey-pair authentication