Snowflake Performance Automation and Tuning
- Offered bySnowflake
Snowflake Performance Automation and Tuning at Snowflake Overview
Duration | 3 days |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Snowflake Performance Automation and Tuning at Snowflake Highlights
- Earn a certificate after completion of the course
Snowflake Performance Automation and Tuning at Snowflake Course details
- Technical Team Leads
- Data Architects
- Snowflake Administrators
- Data Engineers
- Data Application Developers
- Work effectively and efficiently with the key capabilities and best practices behind Snowflake’s Cloud Data Platform three-tiered architecture designed for performance and scale
- Apply the right set of Snowflake-provided tools for performance assessment and optimization
- Use Snowflake’s tuning methodology on established performance features, including best practices and avoiding pitfalls to work efficiently with the platform
- Explore emerging performance features with suitable use cases and adoption of best practices
- This three-day accelerated course presents key performance capabilities, Snowflake best practices, and tuning techniques that are designed to help participants to use Snowflake’s Cloud Data Platform to develop diverse, high-performance workloads
- The course illustrates performance design best practices and pitfalls so participants are prepared to apply the methodology and features to their own diverse workloads
Snowflake Performance Automation and Tuning at Snowflake Curriculum
Overview and Architecture
Overview
Snowflake Architecture Review
Cloud Services Layer
Performance Diagnostic and Tuning Toolset
Query Profile
Explain Plan
Query Pruning
Data Zones
Data Zones
Tuning for the Raw Data Zone
Bulk Loading Data
Transforming Data on Load
Continuous Data Loading
External Tables and Data Lakes
External Tables
Data Lake
Snowflake Recommendations for External Tables and Data Lakes
Query Processing and Execution
Optimization Principles and Techniques
Query Processing and Optimizations
Snowflake Query Best Practices and Tuning
Order By Tuning Scenarios
Snowflake SQL Query Best Practices: Searching and Filtering
Snowflake SQL Best Practices: Multi-step Advanced SQL
Subquery
Subquery Tuning
Snowflake Performance Automation and Tuning at Snowflake Entry Requirements
- Snowflake Fundamentals (FUND) or Snowflake Advanced (ADV)
- Not mentioned
Other courses offered by Snowflake
Student Forum
Anything you would want to ask experts?