Course content
Course Content
- Introduction to Snowflake
- Quick Start to Snowflake
- Accessing Trial Account
- Creating Warehouse, Database, Schema and Tables
- Accessing Different Roles and Using Them
- Working with Worksheets
- Understanding Cloud Platforms
- Snowflake Architecture and Caching
- Azure and Understanding Blob Storage
- High-Level Understanding of AWS and GCP Buckets
- Data Loading and Unloading in Snowflake
- File Formats
- Internal and External Storage
- COPY INTO Command and Usage
- Internal Storage
- Accessing Cloud Data into Snowflake
- Data Unloading
- Snowpipe
- Bulk Loading
- Continuous Loading
- Partner Connect with Snowflake
- Snowflake Connectors
- BI Connectors
- Handling Different Types of Files
- VARIANT Data Type
- File Format Options
- Creating Stages
- Loading JSON Files
- Scheduling with Snowflake
- Creating Tasks
- Streams
- Secure Data Sharing
- Sharing Data with Different Accounts
- Sharing Data with Non-Snowflake Accounts
- Reader Accounts
- Connecting with BI Tools like Power BI
- Cloning
- Time Travel and Fail-Safe
- Introduction to Time Travel
- Enabling and Disabling Time Travel
- Data Retention Period
- Clustering and Performance Techniques
- Dynamic Data Masking