Snowflake - Pricing Model




Snowflake - Pricing Model

Snowflake uses three different stages or layers for their services to end-users −

  • Storage
  • Virtual Warehouse (Compute)
  • Cloud Services

Snowflake doesn't have any license cost. However, the pricing is based on the actual usage of these three layers plus serverless features. Snowflake charges a fixed amount plus any additional costs based on the usage of Snowflake credits.

What is Snowflake Credit?

It is the mode of payment for the consumption of the snowflake resources, usually Virtual Warehouses, Cloud Services, and serverless features. Snowflake credit is a unit of measure. It is calculated based on resources utilized, it doesn't charge anything if the customer is not using any resources or resources are in sleep mode. For example, a snowflake credit is used when virtual warehouse is running and the cloud service layer is executing some user-defined task.

Storage Cost

Snowflake charges a monthly fee for the data storage. Storage cost is measured as the average amount of data stored in Snowflake on a monthly basis. This data size is calculated after compression is performed by Snowflake. This cost significantly very low, around $23/1TB data for one month.

Virtual Warehouse (Compute)

It is one or more clusters that is used to load data into Snowflake and execute queries. Snowflake uses Snowflake Credits as a payment from customer.

The snowflake credit is calculated based on Warehouse size, number of clusters and time spent to execute queries. The size of a warehouse determines how fast a query will run. When a virtual warehouse is not running and is in suspended mode, it doesn't spend any Snowflake credit. Different sizes of warehouses spend Snowflake credits at different rates.

Warehouse Size Servers Credit/Hour Credits/Second
X-Small 1 1 0.0003
Small 2 2 0.0006
Medium 4 4 0.0011
Large 8 8 0.0022
X-Large 16 16 0.0044
2X-Large 32 32 0.0089
3X-Large 64 64 0.0178
4X-Large 128 128 0.0356

Cloud Services

Cloud services manage end-to-end solution of the user's task. It automatically assigns resources based on requirements of a task. Snowflake provides free usage of cloud service up to 10% of daily compute credits.

For example, if a user spends 100 Credit daily as Compute, then 10 Credits used for Cloud Services are free of cost.

Serverless Features

Snowflake provides many additional serverless features. These are managed compute resources and Snowflake consumes credit when it is used.

Snowpipe, Database Replication, Materialized Views Maintenance, Automatic Clustering, Search Optimization Service are serverless features provided by Snowflake.



Frequently Asked Questions

+
Ans: Snowflake - Editions view more..
+
Ans: Snowflake - How to Access view more..
+
Ans: Snowflake - Functional Architecture view more..
+
Ans: Snowflake - Pricing Model view more..
+
Ans: Snowflake - Objects view more..
+
Ans: Snowflake - Table & View Types view more..
+
Ans: Snowflake - Login view more..
+
Ans: Snowflake - Warehouse view more..
+
Ans: Snowflake - Database view more..
+
Ans: Snowflake - Schema view more..
+
Ans: Snowflake - Table & Columns view more..
+
Ans: Snowflake - Load Data From Files view more..
+
Ans: Snowflake - Sample Useful Queries view more..
+
Ans: Snowflake - Monitor Usage and Storage view more..
+
Ans: Snowflake - Cache view more..
+
Ans: Unload Data from Snowflake to Local view more..
+
Ans: Snowflake - External Data Loading view more..
+
Ans: Snowflake - External Data Unloading view more..




Rating - NAN/5
544 views

Advertisements