Administering Snowflake II Training
Duration
2 Days
Level
Advanced Level
Design and Tailor this course
Official Course
This two‐day, role‐specific course continues the study and practical lab experience of database and ac‐
count administration. This course includes data recovery scenarios, replication, and advanced tuning
strategies. The course consists of lectures, labs, demonstrations, and discussions.
ACQUIRED SKILLS
• Manage multiple accounts across the company using Snowflake Organization.
• Employ data recovery methods using Time Travel and zero‐copy cloning.
• Implement advanced techniques for Snowflake performance tuning methodologies.
• Utilize Snowflake’s recommended best practices for management, monitoring, and optimization.
• Deploy replication for data sharing across accounts and failover scenarios.
• Share data securely both inside and outside your organization.
• Create and deploy administrative jobs using Snowflake stored procedures and functions.
• Database Administrators
• System Administrators
• Database Architects
• Data Engineers
- Micro‐partitions and Clustering
- Micro‐partition Pruning (Elimination)
- Evaluating Clustering
- Implement and Test Cluster Keys
- Materialized Views
- Search Optimization Service
- Query Acceleration Service (QAS)
• Fail‐safe
• Data Recovery Scenarios
• Snowflake Organizations
• Administrative Operations With Organizations
• ORGADMIN Role
• Snowflake Role Types
• Creating Accounts
• Using Snowflake Database Roles with Organizations
• Querying Organization Account Usage
• Account Management Commands
• Overview
• Replication Workflow
• Failover Workflow
• Client Redirect
• Monitoring Replication
• User‐defined Functions
• JavaScript Stored Procedures
• Snowflake Scripting Overview
• Programmability Enhancements
• Logging and Tracing
• Event Tables
• Using Alerts with Email Notifications
• Managing Data Exchange
• Managing Data Marketplace
• What are Database Roles?
• Database Roles and Data Sharing
• Snowflake Shared Database Roles
• What is a Hybrid Table?
• Implement Hybrid Tables
• Hybrid Table Cost Analysis
• Hybrid Table Limitations
• Table Format Overview
• Iceberg Table Format
• Iceberg Tables in Snowflake Overview
• Snowflake Managed Apache Iceberg™ Tables
• Create Externally Managed Iceberg Tables in Snowflake
• Cost Management in Snowflake
• Monitoring Access_History
• Monitoring Compute
• Monitoring Storage
• Monitoring Data Transfer
• Resource Monitors
• A background in database administration or management is required.
• Completion of “Administering Snowflake” three‐day course or equivalent Snowflake knowledge.