Snowflake Tutorial
Selected Reading
- Snowflake - Discussion
- Snowflake - Useful Resources
- Snowflake - Quick Guide
- External Data Unloading (Into AWS S3)
- External Data Loading (from AWS S3)
- Unload Data from Snowflake to Local
- Snowflake - Cache
- Snowflake - Monitor Usage and Storage
- Snowflake - Sample Useful Queries
- Snowflake - Load Data From Files
- Snowflake - Table & Columns
- Snowflake - Schema
- Snowflake - Database
- Snowflake - Warehouse
- Snowflake - Login
- Snowflake - Table and View Types
- Snowflake - Objects
- Snowflake - Pricing Model
- Snowflake - Editions
- Snowflake - How to Access
- Snowflake - Functional Architecture
- Snowflake - Data Architecture
- Snowflake - Introduction
- Snowflake - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
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 pcense 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 utipzed, 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 Reppcation, Materiapzed Views Maintenance, Automatic Clustering, Search Optimization Service are serverless features provided by Snowflake.
Advertisements