Creating new roles, users, and warehouses

Introduction to Snowflake

Danny Hong

Senior Data Engineer

Snowflake Roles Explained

  • ACCOUNTADMIN manages account-level tasks like billing
  • SECURITYADMIN manages all objects in the account
  • USERADMIN manages access to roles and users it owns
  • SYSADMIN manages any objects it owns
  • PUBLIC can access and manage objects granted to its role
1 https://docs.snowflake.com/en/user-guide/security-access-control-overview#role-hierarchy-and-privilege-inheritance
Introduction to Snowflake

Creating a new role

Introduction to Snowflake

Creating a new user

GIF of creating a new user

Introduction to Snowflake

Why create a new virtual warehouse?

When do we want to do this?

  • Role-based warehouse access
    • Example: Engineers and Analysts
  • Slow query execution
    • Example: Analysis query taking 10+ minutes long

Image of warehouse size and its credits/hour

1 https://docs.snowflake.com/en/user-guide/warehouses-overview#warehouse-size
Introduction to Snowflake

Creating a new virtual warehouse

GIF on creating a new warehouse

Introduction to Snowflake

Let's practice!

Introduction to Snowflake

Preparing Video For Download...