Snowflake Architecture and Overview
- Snowflake Architecture
- Cloud Services Layer
- Data Storage Layer
- Compute Layer
- Sample Data
- Web User Interface
- SnowSQL
Time Travel and Cloning
- Time Travel
- Cloning and Agile Development
Snowflake Structure and SQL
- Snowflake Structure
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
Data Loading
- Data Loading Concepts
- Bulk Loading
Semi-structured Data
- Querying
- Load and Unload
Data Loading Considerations
- Snowflake Best Practices
- Data Loading, Transformations, and Validations
Performance
- Query Profile
Explain Plan
- SQL Performance Tips
- Performance Bottleneck Scenarios
Caching
- Metadata Cache
- Query Result Cache
- Data Cache
Clustering
- Natural Clustering