Join us for a FREE hands-on Meetup webinar on Automate Workflows with Agentic AI – No Coding Needed! | Thursday, April 24th, 2025 · 7:00 PM IST/ 09:30 AM EDT Join us for a FREE hands-on Meetup webinar on Automate Workflows with Agentic AI – No Coding Needed! | Thursday, April 24th, 2025 · 7:00 PM IST/ 09:30 AM EDT

Administering Snowflake II Training

Advanced Techniques in Data Recovery, Replication, and Performance Optimization for Snowflake Administrators

Duration

2 Days

Level

Advanced Level

Design and Tailor this course

Official Course

Edit Content

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.

Edit Content

• Database Administrators
• System Administrators
• Database Architects
• Data Engineers

Edit Content
  • 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

Edit Content

• A background in database administration or management is required.
• Completion of “Administering Snowflake” three‐day course or equivalent Snowflake knowledge.

Connect

we'd love to have your feedback on your experience so far