Hi all
greetings from TS TECHNOLOGIES
We are offering SNOW FLAKE WITH DBT course
course duration:45 days
mode: online
training will be provided by excellent and experienced faculty
please go through the course content
COURSE CONTENTS
Introduction to snowflake
1)Quick start to snowflake
2)Accessing trail account
3)Creating warehouse,DB,Schema and tables
4)Accessing different roles and using it
5)Working with worksheets
Understanding cloud Platforms
1)Snowflake architecture and caching
2)Azure and understanding blob storage
3)High-level understanding of AWS and GCP buckets
Data loading and unloading in snowflake
1)File formats
2)Internal and external storage
3)copy into command and usage
4)Internal storage
5)Accessing cloud data into snowflake
6)Data unloading
Snowpipe
1)Bulk loading
2)Continuous loading
Partner connect with snowflake
1)snowflake connectors
2)BI connectors
Handling different types of file
1)variant Datatype
2)File format options
3)creating stages
4)Loading of JSON files
Scheduling with snowflake
1)Creating Tasks
2)Streams
Secure data sharing
1)Sharing data with different accounts
2)Sharing data with non-SF accounts
3)reader accounts
4)connecting with BI tools like powerbi
5)clone
Time travel and failsafe
1)Intro to time travel
2)enabling and disabling time travel
3)data retention period
clustering and performance techniques
Dynamic Data Masking
Interested candidates
contact TS TECHNOLOGIES
mobile & whats app:9951180008
visit www.tstechnologies.co.in
Login
