Snowflake - Credits
Snowflake Credits : Its a unit of measure on snowflake and its used to pay for the consumption of
resources in Snowflake .
Let’s say you have spent 100 Credits in the month of January , it means the amount that you or your
company would have to pay is : (100 * Cost per Credit) in dollar .
Cost Per Credit - : https://www.snowflake.com/pricing/
Snowflake - Billing Components
● Storage Costs : On-demand (~$40 per TB/month storage) and pre-purchased storage (~$23 per TB
storage/month)
● Compute Costs : Virtual Warehouses (XS to 5XL Large) , per-minute pricing
● Cloud Services Cost : Authentication , infrastructure management, metadata management , query
optimization & access control
● Serverless Features Cost : Snowpipe,Database replication,Materialized View maintenance ,
automatic clustering
Snowflake - Warehouse/Compute Cost
● Cluster Configuration => Medium Sized Warehouse : 4 Credits/hour => 4 Credits / 60 minutes
○ Single Cluster Warehouse
■ 1 minute = 0.066 Credits
■ 30 minutes = 30 * 0.066 = 1.98 Credits
■ Dollar Amount => 1.98 * $3.9 = $7.72
○ Multi Cluster Warehouse (min=1,max=2)
■ 1 minute = 0.066*2 = 0.132 Credits
■ 30 minutes = 30 *0.132= 3.96 Credits
■ Dollar Amount => 3.96 * $3.9 = $15.44
Snowflake - Cloud Services Cost
Date Compute Credits Cloud Services - Credits Adjustments Total Credits
Consumed Consumed Billed
1st Jan 100 20 -10 110
2nd Jan 120 10 -10 120
3rd Jan 80 5 -5 80
Total 300 35 -25 310
Course - Roadmap
Course Content : 12 Major Sections
● Section 2 : Basic Fundamentals of cloud data-warehouse , AWS Cloud & the main Components of Snowflake
● Section 3 : Snowflake - Table Types
● Section 4 : Clustering , partitions and performance optimizations
● Section 5 :Data Loading/Extraction
● Section 6 : Tasks & Query Scheduling
● Section 7 : Streams & CDC
● Section 8 & 9 : UDFs & External Functions (Python)
● Section 10: AWS & Python for Snowflake
● Section 11 : Read Time Streaming using Kafka & Snowflake
● Section 12 : Data Protection & Security
● Section 13: Extra Tips,reference materials and what’s next
Course - More Updates
New Sections Coming up Soon :
● Stored Procedures
● Different Data Modelling Techniques
● Snowpark (Python) - Preview Mode
About the
About me :
● Over 12 years of experience in software engineering
and building data data pipelines for BI & data analytics
● Worked in various domains such as retail , ecommerce , product based
Companies & Telco
● Experience in building pipelines using micro-services,spark,
BigQuery,Redshift , Airflow , apache beam and other serverless components on cloud
● Around 2 years of experience on building solutions using Snowflake .
● LinkedIn : https://www.linkedin.com/in/sid794/
Course Prerequisites & how to succeed
- For people who have a background in software/data engineering , data analysts , DBAs and programmers
- About 85% of the course is only SQL and is done using Snowflakes Web UI
- Prior experience in SQL is a must .
- Prior experience in cloud is a must (AWS , GCP , Azure ) , at least the basics and know-how
- No specific softwares need to be installed , only python and pandas .
- For Real time streaming Section , you need to install Kafka in your local system
- Right Attitude :-)
- Every section has an sql file called “initial_setup.sql”
- Course will be updated on a bi-weekly basis with new videos/sections
- Repo for this Course : https://github.com/siddd88/snowflake-aws-udemy
Whats next ?
More to Come :
- Example questions and solutions to Snowpro-Certification Exams
- Snowpark with Python
- Developing & deploying Machine learning Models with Snowflake
