100% Free Forever
AI-Powered Learning
Industry Expert Content
Certificates & Badges
Learn At Your Own Pace
Programming

Setting Up a Snowflake Account

A practical walkthrough of creating a Snowflake account, choosing an edition and region, and configuring initial roles and warehouses.

FoundationsBeginner7 min readJul 10, 2026
Analogies

Setting Up a Snowflake Account

Getting started with Snowflake begins with signing up for a trial or paid account, during which you choose a cloud provider (AWS, Azure, or GCP), a region, and an edition (Standard, Enterprise, Business Critical, or VPS) — decisions that affect pricing, available features like time travel retention, and where your data physically resides for compliance purposes.

🏏

Cricket analogy: Like registering a new franchise before an IPL season, you must first pick your home ground (cloud region), your league division (edition), and your city base (provider) before a single ball is bowled.

Choosing an Edition and Cloud Region

The edition you pick determines feature availability and per-credit pricing: Standard covers core warehousing, Enterprise adds features like multi-cluster warehouses and longer Time Travel (up to 90 days), and Business Critical adds enhanced security for regulated industries like healthcare or finance. Region selection matters too — choosing a region close to your users reduces latency, and choosing a region matching your data residency laws (e.g., an EU region for GDPR-sensitive data) can be a compliance requirement, not just a performance one.

🏏

Cricket analogy: Like choosing between playing in the domestic Ranji Trophy (Standard), the higher-stakes IPL (Enterprise, more features), or an internationally regulated tournament like the World Cup with extra anti-corruption scrutiny (Business Critical for compliance).

Account URL, Roles, and Initial Login

Every Snowflake account gets a unique URL like orgname-accountname.snowflakecomputing.com, and the first user created during signup becomes the ACCOUNTADMIN, the most privileged role in the system, capable of creating other users, warehouses, and roles. Snowflake's role-based access control (RBAC) model means you should immediately create a lower-privileged role like SYSADMIN for day-to-day object creation and avoid using ACCOUNTADMIN for routine work, following the principle of least privilege.

🏏

Cricket analogy: Like the BCCI president holding ultimate authority to appoint selectors and captains but delegating day-to-day team decisions to a head coach — ACCOUNTADMIN similarly delegates routine work to SYSADMIN rather than doing everything itself.

sql
-- As ACCOUNTADMIN: create a lower-privileged role for daily work
USE ROLE ACCOUNTADMIN;

CREATE ROLE IF NOT EXISTS DATA_ENGINEER;
GRANT ROLE DATA_ENGINEER TO USER JDOE;

CREATE WAREHOUSE IF NOT EXISTS DEV_WH
  WAREHOUSE_SIZE = 'XSMALL'
  AUTO_SUSPEND = 60
  AUTO_RESUME = TRUE;

GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DATA_ENGINEER;

Configuring Warehouses and Users

Once logged in, a sensible first step is creating a small warehouse (e.g., X-Small) for initial exploration, since Snowflake trial accounts start with limited free credits that get consumed by compute usage, and setting AUTO_SUSPEND to a low value like 60 seconds prevents an idle warehouse from silently burning through your trial credits overnight.

🏏

Cricket analogy: Like a franchise renting practice nets by the hour and making sure the lights auto-switch-off after the session so unused booked time doesn't quietly drain the budget overnight.

Free trial accounts come with a fixed pool of credits (commonly $400 worth) and a time limit; monitor consumption early using SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY so an oversized or always-on warehouse doesn't exhaust the trial before you've finished evaluating the platform.

  • Signing up requires choosing a cloud provider, region, and edition (Standard, Enterprise, Business Critical, VPS).
  • Edition affects features like Time Travel retention and pricing per credit.
  • Region choice affects latency and can be a data-residency compliance requirement.
  • The first user is ACCOUNTADMIN, the most privileged role — avoid using it for daily work.
  • Create a lower-privileged role like SYSADMIN early, following least-privilege principles.
  • Trial accounts have a fixed credit pool; set AUTO_SUSPEND low to avoid wasting credits.
  • Every account has a unique URL in the form orgname-accountname.snowflakecomputing.com.

Practice what you learned

Was this page helpful?

Topics covered

#Programming#SnowflakeStudyNotes#SettingUpASnowflakeAccount#Setting#Snowflake#Account#Choosing#StudyNotes#SkillVeris#ExamPrep