Snowflake offers multiple editions to choose from, ensuring that your usage fits your organization’s specific requirements. Each successiveedition builds on the previous edition through the addition of edition-specific features and/or higher levels of service. As yourorganization’s needs change and grow, changing editions is easy.
For information about working with editions, including viewing and changing an account’s edition, see Working with Account Editions.
Note
The Snowflake Edition that your organization chooses determines the unit costs for the credits and the data storage you use. Other factorsthat impact unit costs are the region where your Snowflake account is located and whether it isan On Demand or Capacity account:
On Demand: Usage-based pricing with no long-term licensing requirements.
Capacity: Discounted pricing based on an upfront Capacity commitment.
For pricing details, see the pricing page (on the Snowflake website).
Overview of Editions¶
Standard Edition¶
Standard Edition is our introductory level offering, providing full, unlimited access to all of Snowflake’s standard features. It providesa strong balance between features, level of support, and cost.
Enterprise Edition¶
Enterprise Edition provides all the features and services of Standard Edition, with additional features designedspecifically for the needs of large-scale enterprises and organizations.
Business Critical Edition¶
Business Critical Edition, formerly known as Enterprise for Sensitive Data (ESD), offers even higher levels of data protection to supportthe needs of organizations with extremely sensitive data, particularly PHI data that must comply with HIPAA andHITRUST CSF regulations.
It includes all the features and services of Enterprise Edition, with the addition of enhanced security and dataprotection. In addition, database failover/failback adds support for business continuity and disaster recovery.
Note
As required by HIPAA and HITRUST CSF regulations, before any PHI data can be stored in Snowflake, asigned business associate agreement (BAA) must be in place between your agency/organization and Snowflake Inc.
Virtual Private Snowflake (VPS)¶
Virtual Private Snowflake offers our highest level of security for organizations that have the strictest requirements, such as financialinstitutions and any other large enterprises that collect, analyze, and share highly sensitive data.
It includes all the features and services of Business Critical Edition, but in a completely separate Snowflakeenvironment, isolated from all other Snowflake accounts (i.e. VPS accounts do not share any resources with accounts outside the VPS).However, you may choose to enable data sharing with non-VPS customers. See Support for Auto-fulfillment in Virtual Private Snowflake for more details.
Note
To access your account, you can use an account identifier that specifies yourorganization name and account name.
If you instead choose to use an account locator as the account identifier, note thatthe account locator for VPS accounts uses a different format than the accounts for other Snowflake Editions. For details, seeFinding the Account Locator Format for a VPS Account.
Feature / Edition Matrix¶
The following tables provide a list of the major features and services included with each edition.
Note
This is only a partial list of the features. For a more complete and detailed list, see Overview of Key Features.
Release Management¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
12-hour early access to weekly new releases, which can be used for additional testing/validation before each release is deployed to your production accounts. | ✔ | ✔ | ||
24-hour early access to weekly new releases, which can be used for additional testing/validation before each release is deployed to your production accounts. | ✔ |
Security, Governance, & Data Protection¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
SOC 2 Type II certification. | ✔ | ✔ | ✔ | ✔ |
Federated authentication and SSO for centralizing and streamlining user authentication. | ✔ | ✔ | ✔ | ✔ |
OAuth for authorizing account access without sharing or storing user login credentials. | ✔ | ✔ | ✔ | ✔ |
Network policies for limiting/controlling site access by user IP address. | ✔ | ✔ | ✔ | ✔ |
Automatic encryption of all data. | ✔ | ✔ | ✔ | ✔ |
Support for multi-factor authentication. | ✔ | ✔ | ✔ | ✔ |
Object-level access control. | ✔ | ✔ | ✔ | ✔ |
Standard Time Travel (up to 1 day) for accessing/restoring modified and deleted data. | ✔ | ✔ | ✔ | ✔ |
Disaster recovery of modified/deleted data (for 7 days beyond Time Travel) through Fail-safe. | ✔ | ✔ | ✔ | ✔ |
Extended Time Travel (up to 90 days). | ✔ | ✔ | ✔ | |
Periodic rekeying of encrypted data for increased protection. | ✔ | ✔ | ✔ | |
Column-level Security to apply masking policies to columns in tables or views. | ✔ | ✔ | ✔ | |
Row-level Security to apply row access policies to determine which rows are visible in a query result. | ✔ | ✔ | ✔ | |
Object Tagging to apply tags to Snowflake objects to facilitate tracking sensitive data and resource usage. | ✔ | ✔ | ✔ | |
Support for classifying potentially sensitive data using classification. | ✔ | ✔ | ✔ | |
Audit the user access history through the Account Usage ACCESS_HISTORY view. | ✔ | ✔ | ✔ | |
Customer-managed encryption keys through Tri-Secret Secure. | ✔ | ✔ | ||
Support for private connectivity to the Snowflake service using AWS PrivateLink, Azure Private Link, or Google Cloud Private Service Connect. | ✔ | ✔ | ||
Support for private connectivity to Snowflake internal stages using AWS PrivateLink and Azure Private Link. | ✔ | ✔ | ||
Support for PHI data (in accordance with HIPAA and HITRUST CSF regulations). | ✔ | ✔ | ||
Support for PCI DSS. | ✔ | ✔ | ||
Support for public sector workloads that meet U.S. Federal and state government requirements, such as FedRAMP and ITAR. | ✔ | ✔ | ||
Support for IRAP - Protected (P) data (in specified Asia Pacific regions). | ✔ | ✔ | ||
Dedicated metadata store and pool of compute resources (used in virtual warehouses). | ✔ |
Compute Resource Management¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Virtual warehouses, separate compute clusters for isolating query and data loading workloads. | ✔ | ✔ | ✔ | ✔ |
Resource monitors for monitoring virtual warehouse credit usage. | ✔ | ✔ | ✔ | ✔ |
Multi-cluster virtual warehouses for scaling compute resources to meet concurrency needs. | ✔ | ✔ | ✔ |
SQL Support¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Standard SQL, including most DDL and DML defined in SQL:1999. | ✔ | ✔ | ✔ | ✔ |
Advanced DML such as multi-table INSERT, MERGE, and multi-merge. | ✔ | ✔ | ✔ | ✔ |
Broad support for standard data types. | ✔ | ✔ | ✔ | ✔ |
Native support for semi-structured data (JSON, Avro, ORC, Parquet, and XML). | ✔ | ✔ | ✔ | ✔ |
Native support for geospatial data. | ✔ | ✔ | ✔ | ✔ |
Native support for unstructured data. | ✔ | ✔ | ✔ | ✔ |
Collation rules for string/text data in table columns. | ✔ | ✔ | ✔ | ✔ |
Integrity constraints (not enforced) on table columns for informational and modeling purposes. | ✔ | ✔ | ✔ | ✔ |
Multi-statement transactions. | ✔ | ✔ | ✔ | ✔ |
User-defined functions (UDFs) with support for Java, JavaScript, Python, and SQL. | ✔ | ✔ | ✔ | ✔ |
External functions for extending Snowflake to other development platforms. | ✔ | ✔ | ✔ | ✔ |
Amazon API Gateway private endpoints for external functions. | ✔ | ✔ | ||
Stored procedures with support for Java, JavaScript, Python, Scala, and SQL (Snowflake Scripting). | ✔ | ✔ | ✔ | ✔ |
External tables for referencing data in a cloud storage data lake. | ✔ | ✔ | ✔ | ✔ |
Hybrid tables for data in transactional and analytical workloads. | ✔ | ✔ | ✔ | ✔ |
Support for clustering data in very large tables to improve query performance, with automatic maintenance of clustering. | ✔ | ✔ | ✔ | ✔ |
Query acceleration for parallel processing portions of eligible queries. | ✔ | ✔ | ✔ | |
Search optimization for point lookup queries, with automatic maintenance. | ✔ | ✔ | ✔ | |
Materialized views, with automatic maintenance of results. | ✔ | ✔ | ✔ |
Interfaces & Tools¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Snowsight, the next-generation SQL worksheet for advanced query development, data analysis, and visualization. | ✔ | ✔ | ✔ | ✔ |
SnowSQL, a command line client for building/testing queries, loading/unloading bulk data, and automating DDL operations. | ✔ | ✔ | ✔ | ✔ |
SnowCD, a command line diagnostic tool for identifying and fixing client connectivity issues. | ✔ | ✔ | ✔ | ✔ |
Programmatic interfaces for Python, Spark, Node.js, .NET.js, PHP, and Go. | ✔ | ✔ | ✔ | ✔ |
Native support for JDBC and ODBC. | ✔ | ✔ | ✔ | ✔ |
Snowflake SQL API, a REST API for accessing and updating data in a Snowflake database. | ✔ | ✔ | ✔ | ✔ |
Extensive ecosystem for connecting to ETL, BI, and other third-party vendors and technologies. | ✔ | ✔ | ✔ | ✔ |
Snowflake Partner Connect for initiating free software/service trials with a growing network of partners in the Snowflake ecosystem. | ✔ | ✔ | ✔ | ✔ |
Snowpark, the set of libraries and runtimes that securely deploy and process non-SQL code, including Python, Java, and Scala. | ✔ | ✔ | ✔ | ✔ |
Streamlit in Snowflake for building, deploying, and sharing Streamlit apps on Snowflake data cloud. | ✔ | ✔ | ✔ | ✔ |
Data Import & Export¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Bulk loading from delimited flat files (CSV, TSV, etc.) and semi-structured data files (JSON, Avro, ORC, Parquet, and XML). | ✔ | ✔ | ✔ | ✔ |
Bulk unloading to delimited flat files and JSON files. | ✔ | ✔ | ✔ | ✔ |
Snowpipe for continuous micro-batch loading. | ✔ | ✔ | ✔ | ✔ |
Snowflake Connector for Kafka for loading data from Apache Kafka topics. | ✔ | ✔ | ✔ | ✔ |
Data Pipelines¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Streams for tracking table changes. | ✔ | ✔ | ✔ | ✔ |
Tasks for scheduling the execution of SQL statements, often in conjunction with table streams. | ✔ | ✔ | ✔ | ✔ |
Data Replication & Failover¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Database and share replication between Snowflake accounts (within an organization)to keep database and share objects and stored data synchronized. | ✔ | ✔ | ✔ | ✔ |
Failover and failback between Snowflake accounts for business continuityand disaster recovery. | ✔ | ✔ | ||
Redirecting Client Connections between Snowflake accounts for business continuity and disaster recovery. | ✔ | ✔ |
Data Sharing¶
Note
By default, VPS does not permit data sharing outside of the VPS. However, you can enable data sharing with non-VPS customersby contacting Snowflake Support. See Support for Auto-fulfillment in Virtual Private Snowflake for more details.
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
As a data provider, securely share data with other accounts. | ✔ | ✔ | ✔ | |
As a data consumer, query data shared with your account by data providers. | ✔ | ✔ | ✔ | |
Secure data sharing across regions and cloud platforms (through data replication) | ✔ | ✔ | ✔ | |
Snowflake Marketplace and Listings, where providers and consumers meet to share data securely. | ✔ | ✔ | ✔ | |
Data Exchange, a private hub of administrators, providers, and consumers that you invite to securely collaborate around data. | ✔ | ✔ | ✔ |
Customer Support¶
Feature/Service | Standard | Enterprise | BusinessCritical | VPS |
|---|---|---|---|---|
Snowflake Community, Snowflake’s online Knowledge Base and support portal (for logging and tracking Snowflake Support tickets). | ✔ | ✔ | ✔ | ✔ |
Premier support, which includes 24/7 coverage and 1-hour response window for Severity 1 issues. | ✔ [1] | ✔ | ✔ | ✔ |
[1] Applies only to Standard accounts provisioned after May 1, 2020; Standard accounts provisioned before May 1 will continue to receive Standard support (as defined in ‘Support Policy and Service Level Agreement’) until the account is transitioned to Premier support.
