May 2025

If you’re managing access in Snowflake and want to keep things clean, secure, and easy to reason about, it helps to understand what the built-in roles are actually for. Here’s a breakdown of the standard roles Snowflake provides, what they can do, and how I typically see them used in practice. ACCOUNTADMIN The most powerful […]

I recently had to load data into Snowflake from a headless EC2 Linux 2023 instance. Easy, right? Until you realize that your org uses Okta SSO and SnowSQL’s go-to option is –authenticator externalbrowser. Great—except there’s no browser on this box. After trying a few dead ends (including looking for a magical –output oauth flag that