SNOW FLAKE
About Course
Faculty having 18 years of experience in TOP MNCs on Banking, Insurance, Sales etc. domains
In-depth Training with real time use cases
Two projects
Practical Lab for every concept
Internship facility
Interview Preparation
Work Experience
100% Placement Support
Job Support after placement
Topics of Course
Introduction
-
Getting Standard
Getting Started
Free trail
Creating account
User Interface
Architecture
Warehouse creation
Warehouse using sql
Creating Virtual Warehouse
Scaling
Tables & databases
loading data in snowflake -
snow flake architecture
What is data warehouse
Snowflake pricing
Monitoring the snowflake
Roles in Snowflake -
Loading Data
Loading methods
Understanding the stages
Creating stage
Copy command
Transforming data
More transformations
Copy option
File format -
copy options
Understanding copy options
Validation_Mode
Working with rejected records
Size_limit
Return_failed_only
Truncate columns
Force
Load history -
Loading unstructure Data
Creating stage & Raw file
Parsing Json
Handling Nested data
Dealing with Hierarchy
Inserting final data
Querying Parquet data
Loading Parquet data -
performance optimization
Performance in snowflake
Create dedicated Virtual warehouse
Implement dedicated virtual warehouse
Scaling up
Scaling out
Scaling
Maximize Caching
Clustering -
Loading from AWS
Sign up for free trial
Creating S3 bucket
Upload files in S3
Creating Policy
Creating Integration object
Loading from S3 -
Loading from Azure
Free Trail
Create a Storage Account
Create a Container
Create Integration Object
Create Stage Object
Load CSV file
Load JSON File -
Loading from GCP
Free Trail
Create a Bucket
Create Integration Object
Create Stage
Query & Load Data
Unload data -
Snow pipe
What is Snowpipe
Creating Stage
Creating pipe
Configuring pipe & notification
Error Handling
Mange Pipes -
Snow pipe Azure
Creating Stage & storage integration
Creating notification integration
Creating pipe and load data -
Time Travel
Using Time Travel
Restoring Data
Undrop tables
Retention time
Time travel cost -
Fall Safe
Understanding Fail Safe
Fail Safe storage -
Time of Tables
Different table types
Permanent tables & databases
Transient tables & databases
Temporary tables & databases -
Zero Copy Coloning
What is zero-copy cloning
Cloning tables
Cloning schemas & databases
Cloning with time travel
Swapping tables -
Data Sharing
What is Data Sharing
Using Data Sharing
Create Share through the Interface
Sharing with non-snowflake users
Creating a reader account
Creating a database from share
Setup users for Share
Sharing database & Schema
Secure vs normal view
Sharing a source View -
Data Sampling
Why data Sampling
Methods of data sampling
Sampling data with an Example -
Scheduling Tasks
Understanding tasks
Creating tasks
Using CRON
Understanding tree of tasks
Creating trees of tasks
Calling the stored procedure
Task history & Error Handling -
Streams
Understanding Streams
CURD operations
Process all the data changes
Combine streams & tasks
Types of StreamsChanges Clause
-
Materialized views
Understanding materialized Views
Using Materialized View
Refresh materialized views
Maintaince costs
When to use materialized views
Limitation -
Dynamic Data Malding
Understand Data Masking
Creating a masking Policy
Unset & Replicate policy
Alter an existing Policy
Real life examples -
Access Manegements
Key Concepts
Roles Overview
AccountAdmin
Securityadmin
Sysadmin
Custom Roles
UserADMIN
PUBLIC -
visulization and power BI &Tableaus
Data Visualization
Download & Install Power BI
Connect Power BI & SnowFlake
Working with PowerBI
Download & Install Tableau
Connect Tableau & snowflake
Connect to Other Tools
Connect to Databricks
