Snowflake Note I - General Introduction

General Introduction

Basic ideas about Snowflake

  • Separation of storage and compute
  • Built for Cloud environment
    • built from scratch
    • optimized for cloud
    • storage & compute is decoupled
  • Software as a Service
    • No software, infrastructure or upgrade to manage
  • Pay only for used compute & storage
    • Storage & compute charged independently, only for use
  • Scalable
    • Virtual warehouse enable compute scaling
  • Authentication
  • Configuration
  • Resource Management
  • Data Protection
  • Availability
  • Optimization

Unique features in Snowflake

  • Time travel
  • Cloning

snowflake key features

More details can be found at Post not found: snowflake-online-talk Snowflake Online Talk

Basic components in Snowflake

  • Databases
    • data storage layer
  • Warehouse
    • data computation layer
  • Worksheet
    • query window

Price Model

Storage Cost

  • AWS S3 or Azure Blob Storage
  • Based on actual usage
  • Columnar Compression (e.g. Apache Parquet) or other techniques to save cost

Compute Cost

  • Loading data
  • Processing data
  • Only for actual usage
  • Virtual warehouse can help minimize costs

Data Transfer

  • No cost for transferring into Snowflake
  • Costs on transfer out to other regions and to other cloud platforms


  • no cost
  • Database definitions
  • table definitions
  • users permission configuration


AWS Cloud Practitioner Exam Preparation


General Information

  • Introduction to AWS Certified Cloud Practitioner
  • Examination time is around 90 minutes.
  • Examination score is between 100-1000, and the minimum passing score is 700.

Exam Content Outline

Domain 1 - Cloud Concepts (26%):

1.1 Define the AWS Cloud and it’s value proposition
1.2 Identify aspects of AWS Cloud economics
1.3 List the different cloud architecture design principles

Domain 2 - Security and Compliance (25%):

2.1 Define the AWS Cloud shared responsibility model
2.2 Define AWS Cloud security and compliance concepts
2.3 Identify AWS access management capabilities
2.4 Identify resources for security support

Domain 3 - Technology (33%)

3.1 Define method of deploying and operating in the AWS Cloud
3.2 Define the AWS global infrastructure
3.3 Identify the core AWS services
3.4 Identify resources for technology support

Domain 4 - Billing and Pricing (16%)

4.1 Compare and contrast the various pricing models for AWS
4.2 Recognize the various account structures in relation to AWS billing and pricing
4.3 identify resources available for billing support