Snowflake AI Data Cloud Features & Architecture · Topic 2 of 17
Snowflake Editions, Snowsight, Snowflake CLI and IDE Integrations
Compare Standard, Enterprise, Business Critical and VPS editions, then learn Snowsight, Snowflake CLI and the VS Code extension for the COF-C03 exam.
- 5 min
- Four editions, each adding to the one below: Standard, Enterprise, Business Critical, VPS.
- Enterprise: multi-cluster warehouses, up to 90 days Time Travel, materialized views, search optimization, masking and row access policies.
- Business Critical: Tri-Secret Secure, private connectivity, failover and failback, HIPAA and PCI DSS support.
What it is
A Snowflake account is created with an edition. The edition decides which features are available, such as multi-cluster warehouses or customer-managed keys. Each higher edition includes everything in the editions below it.
You then work with the account through interfaces: Snowsight in the browser, Snowflake CLI on the command line, and IDE integrations such as the Snowflake extension for Visual Studio Code. Drivers and connectors are covered in the connectivity chapter.
How it works
Editions compared
| Feature | Standard | Enterprise | Business Critical | Virtual Private Snowflake (VPS) |
|---|---|---|---|---|
| Time Travel maximum | 1 day | 90 days | 90 days | 90 days |
| Multi-cluster warehouses | No | Yes | Yes | Yes |
| Materialized views, search optimization, Query Acceleration Service | No | Yes | Yes | Yes |
| Masking policies and row access policies | No | Yes | Yes | Yes |
| Tri-Secret Secure (customer-managed key) | No | No | Yes | Yes |
| Private connectivity (for example AWS PrivateLink) | No | No | Yes | Yes |
| Failover and failback, client redirect | No | No | Yes | Yes |
| HIPAA and PCI DSS support | No | No | Yes | Yes |
| Separate environment, dedicated metadata store | No | No | No | Yes |
Features present in every edition include Fail-safe, Secure Data Sharing, network policies, MFA, SSO, resource monitors, database replication and always-on encryption of data at rest and in transit.
Pick the edition from the requirement in the scenario:
- "Many concurrent users" or "Time Travel longer than one day" -> at least Enterprise.
- "Column masking" or "row-level security" -> at least Enterprise.
- "Regulated health data", "customer-managed encryption key", "private connectivity" or "failover to another region" -> Business Critical.
- "Must share no hardware or metadata with other customers" -> VPS.
Snowsight
Snowsight is the Snowflake web interface and the main way most users work with the platform. From one browser session you can:
- Write and run SQL or Python in worksheets, and build simple charts and dashboards.
- Create Snowflake Notebooks and Streamlit in Snowflake apps.
- Browse databases, schemas and objects, preview data and view DDL.
- Monitor query history and query profiles, copy history, tasks and other activity.
- Manage warehouses, users, roles, cost and resource monitors (with the right role).
- Discover data in Snowflake Marketplace and manage listings and shares.
What you can see and do depends on the active role selected in Snowsight, exactly like in SQL.
Snowflake CLI
Snowflake CLI is the open-source command-line tool for developers, run with the snow command. Snowflake now treats it as the preferred command-line client; SnowSQL is the legacy client, and new development is focused on Snowflake CLI.
Connections are stored in a config.toml file. Typical commands:
| Command | Purpose |
|---|---|
snow connection add, snow connection test | Define and test a connection |
snow sql -q "SELECT 1" | Run SQL or a SQL file |
snow stage copy | Upload or download files to a stage |
snow snowpark deploy | Deploy Snowpark functions and procedures |
snow streamlit deploy | Deploy a Streamlit in Snowflake app |
snow app run | Build and run a Snowflake Native App |
Because it is scriptable, Snowflake CLI fits CI/CD pipelines and project templates, where a person clicking in Snowsight does not.
IDE integrations
The Snowflake extension for Visual Studio Code lets developers work in their editor instead of the browser. It can:
- Run SQL from
.sqlfiles and view results and query history. - Browse databases and schemas in an object explorer and preview data.
- List, upload and download files in stages.
- Set the session role, database, schema and warehouse.
- Debug Snowpark Python and work with Snowflake Native App projects.
The extension can reuse the same connection definitions as Snowflake CLI (config.toml), so one setup serves both tools.
When a question says "automate deployments in a pipeline", the answer is Snowflake CLI. When it says "work interactively in the browser" or "monitor query history with a visual profile", the answer is Snowsight.
How the exam asks about this
- "A company needs a 30-day Time Travel window" -> Enterprise or higher.
- "Healthcare data, customer-managed keys via Tri-Secret Secure" -> Business Critical.
- "A team wants a command-line tool to deploy Streamlit apps from a CI job" -> Snowflake CLI.
Common mistakes
Picking Standard for multi-cluster warehouses. Multi-cluster warehouses need Enterprise Edition or higher. On Standard you can only scale up, not out.
Thinking Secure Data Sharing needs a high edition. Sharing is available in all editions. Failover and failback of replicated accounts need Business Critical.
Treating SnowSQL as the strategic CLI. SnowSQL still works but is legacy. Questions about the current developer command line point to Snowflake CLI.
Confusing Business Critical with VPS. Business Critical adds compliance and key-management features on shared infrastructure. Only VPS gives a completely separate environment.
What to remember for the exam
- Four editions, each adding to the one below: Standard, Enterprise, Business Critical, VPS.
- Enterprise: multi-cluster warehouses, up to 90 days Time Travel, materialized views, search optimization, masking and row access policies.
- Business Critical: Tri-Secret Secure, private connectivity, failover and failback, HIPAA and PCI DSS support.
- VPS: fully isolated environment with a dedicated metadata store.
- Snowsight is the web UI for worksheets, Notebooks, Streamlit, monitoring and administration.
- Snowflake CLI (
snow) is the open-source developer CLI; SnowSQL is legacy. - The VS Code extension runs SQL, browses objects and stages, and supports Snowpark and Native App development.
Do not choose an edition by price or size of company. The exam always gives a feature requirement, and the lowest edition that meets it is the answer.
Check yourself
What is the lowest edition that supports a multi-cluster warehouse?
Enterprise Edition. Standard Edition supports only single-cluster warehouses.
Which edition is required for Tri-Secret Secure and failover between regions?
Business Critical Edition (and VPS, which includes everything in Business Critical).
Which tool should a team use to deploy Snowpark code from a CI/CD pipeline?
Snowflake CLI, using commands such as snow snowpark deploy with a connection defined in config.toml.
Topic 2 of 17 in Snowflake AI Data Cloud Features & Architecture
Test yourself on Snowflake AI Data Cloud Features & Architecture
The full Snowflake SnowPro Core COF-C03 question bank has 845 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.