Specifying Snowflake Roles

Some Snowflake service accounts are like Swiss Army knives - they have multiple roles, each with its own permissions and environment. Until now, Artie simply authenticated with the service account's default role. That worked for straightforward setups, but for teams running multiple environments (like staging, pre-prod, and prod) from a single service account, it meant juggling credentials or sticking to a one-size-fits-all role.

You can now tell Artie exactly which Snowflake role to use when authenticating with a service account.

Example: If your company runs staging, pre-prod, and prod in Artie, you can use a single service account for all of them - just assign a different role per environment. This keeps credentials simple while ensuring each environment only has access to what it needs.

Why this matters:

• Simplifies credential management - no more creating and rotating multiple service accounts for different environments
• Keeps environments isolated - staging stays staging, prod stays prod, even with the same account
• Supports better security practices - roles can be scoped to the exact permissions needed
• Reduces operational overhead - fewer accounts to configure, monitor, and maintain