Snowflake Online Training

Snowflake is based on cloud data warehouse that can store and analyze all your data
records in one place. It can automatically scale up or down its compute resources to load,
combine, and analyse data. Snowflake grants a data warehouse which is faster, easy to set
up, and far more flexible. With its special features, it soon became a leader in data
management solutions for analytics.
Snowflake’s architecture has the following three components:
 Storage: Snowflake utilizes a scalable cloud storage service to make sure a high
degree of data replication, scalability, and availability without much manual user
intervention. It provides users to organize information in databases, as per their
needs.
 Compute: Snowflake utilizes massively parallel processing (MPP) clusters to allocate
compute resources for tasks such as loading, transforming, and querying data. It
offers users to isolate workloads within virtual warehouses.
 Cloud services: Snowflake utilizes a set of services such as metadata, security, access
control, security, and infrastructure management. It provides users to communicate
with client applications such as Snowflake web user interface, JDBC, or ODBC.

Future scope:
Snowflake is speedily taking share from traditional data warehousing service givers. It
quickly growing in Data warehousing sources. The Company is growing at a fast rate; it can
be challenging to put measurable systems to make sure we are growing in the right
direction.
Snowflake has long runways for expansion still ahead. Snowflake is faster and easier to
maintain warehouses with.

Course Content

Cloud Computing 
Cloud computing models
  Deployment models 
  Service models

Snowflake Upgradations
Snowflake editions 
Snowflake Architecture
Snowflake Account creation on various clouds (AWS,Azure,GCP)
Snowflake Login
Snowflake UI overview
Snowflake UI options

Snowflake Connectors
snowsql (Connecting from Backend )

Snowflake Objects 
 Tables
 Tables arrangement in Snowflake (Micro partitions)
 Tables Type (Permanent , Temporary , Transient,Iceberg)
 Time Travel , Fail Safe 
 Time travel implementations
 Fail Safe 
 Staging 
 Stage types (External , Internal (Names, session , table))
 
 Schemas 
 views(Normal,secure,Materialized)
 Stored Procedure 
 Functions(UDF, External Functions)
 Clustering
 
 Data loading
 
   Structured Data 
   Semi-Structured data loading ( Variant Data Type) 
   Copy command
   Snowpipe
   ETL tool Data Loading
 Data unloading

Data Sharing

  Secure data sharing 
  Data Marketplace
  Data Exchange

Access Control

 RBAC 

Data Processing
 Real Time / Micro batch (Stream and Task) 
 Batch
 
Data Security 
  Data Masking
  Row / Column level security
  Tags  
Clustering 
snowpipe & failure of pipe
Snowflake using python