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
In a nutshell
  • 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.

Standardcore platformaddsEnterprisemulti cluster, 90 day Time TraveladdsBusiness CriticalTri Secret Secure, failoveraddsVPSdedicated environment

How it works

Editions compared

FeatureStandardEnterpriseBusiness CriticalVirtual Private Snowflake (VPS)
Time Travel maximum1 day90 days90 days90 days
Multi-cluster warehousesNoYesYesYes
Materialized views, search optimization, Query Acceleration ServiceNoYesYesYes
Masking policies and row access policiesNoYesYesYes
Tri-Secret Secure (customer-managed key)NoNoYesYes
Private connectivity (for example AWS PrivateLink)NoNoYesYes
Failover and failback, client redirectNoNoYesYes
HIPAA and PCI DSS supportNoNoYesYes
Separate environment, dedicated metadata storeNoNoNoYes

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:

CommandPurpose
snow connection add, snow connection testDefine and test a connection
snow sql -q "SELECT 1"Run SQL or a SQL file
snow stage copyUpload or download files to a stage
snow snowpark deployDeploy Snowpark functions and procedures
snow streamlit deployDeploy a Streamlit in Snowflake app
snow app runBuild 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.

Developerlocal filessnow sql or deploySnowflake CLIconfig.toml connectionruns inSnowflake accountobjects and appsCI pipelinegit pushcallsSnowflake CLIsame commandsdeploys toSnowflake accounttest or prod

IDE integrations

The Snowflake extension for Visual Studio Code lets developers work in their editor instead of the browser. It can:

  • Run SQL from .sql files 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.

Exam tip

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.
Watch out

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.