What is Snowflake?
Snowflake is a cloud data platform that it markets as the AI Data Cloud. Snowflake says thousands of organizations use it to unite siloed data, discover and securely share data, and run diverse workloads. It is sold as a fully managed service, so customers do not install or operate the software themselves.
Compute is provided by virtual warehouses. A warehouse is a cluster of compute resources, and it is required for queries and for all DML operations, including loading data into tables. Warehouses come as Standard or Snowpark-optimized, and the documentation recommends Snowpark-optimized warehouses for workloads with large memory requirements such as ML training. Multi-cluster warehouses scale compute to match changing user and query concurrency.
Secure Data Sharing lets an account share selected objects in a database with other Snowflake accounts. Snowflake uses consumption-based pricing, with storage billed monthly on the average amount stored after compression, and customers can buy on demand or as pre-paid capacity. Higher editions add features such as HIPAA, PCI DSS and FedRAMP support, and Virtual Private Snowflake runs in a separate, isolated environment.
Key capabilities
- Virtual warehouses Clusters of compute resources for queries and DML operations
- Warehouse types Standard and Snowpark-optimized, plus multi-cluster warehouses for concurrency
- Secure Data Sharing Share selected database objects with other Snowflake accounts
- Consumption pricing On-demand or pre-paid capacity, with storage billed monthly
- Higher editions Business Critical with HIPAA, PCI DSS and FedRAMP support, and Virtual Private Snowflake
Where Snowflake fits
- SQL queries and data loading on virtual warehouses
- Concurrency scaling with multi-cluster warehouses
- Memory-heavy and ML workloads on Snowpark-optimized warehouses
- Data sharing between Snowflake accounts
- Cost control through consumption-based billing
Reviews of Snowflake
Be the first to share your experience with Snowflake.
Write a review
Loading review form…
Found Snowflake useful? Upvote it todayYour vote helps other IT teams find it in the daily ranking.
