- Snowflake Tutorial
- Snowflake - Home
- Snowflake - Introduction
- Snowflake - Data Architecture
- Snowflake - Functional Architecture
- Snowflake - How to Access
- Snowflake - Editions
- Snowflake - Pricing Model
- Snowflake - Objects
- Snowflake - Table and View Types
- Snowflake - Login
- Snowflake - Warehouse
- Snowflake - Database
- Snowflake - Schema
- Snowflake - Table & Columns
- Snowflake - Load Data From Files
- Snowflake - Sample Useful Queries
- Snowflake - Monitor Usage and Storage
- Snowflake - Cache
- Unload Data from Snowflake to Local
- External Data Loading (from AWS S3)
- External Data Unloading (Into AWS S3)
- Snowflake Resources
- Snowflake - Quick Guide
- Snowflake - Useful Resources
- Snowflake - Discussion
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.
To Continue Learning Please Login