Snowflake Architect Training

Price
$3,000.00 USD

Duration
3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

This 3-day course for Architects and Technical Leaders provides the skills, knowledge, and Snowflake best practices to deploy and operate Snowflake, provide insights and recommendations based upon real-world customer experiences, and the confidence to get the very best out of Snowflake’s technology.

Course Objectives

  • Examine the tradeoffs associated with the available environment and Snowflake Account deployment options.
  • Use the Snowflake data security framework to balance the often-conflicting needs of protecting sensitive data while democratizing access and facilitating sharing.
  • Apply Snowflake best practices to maximize performance and efficient use of resources during data ingestion, transformation, and end user queries.
  • Analyze Snowflake metadata to identify performance and cost issues and recommend remedial action.

Who Should Attend?

  • Solution Architects
  • Data Architects
  • Database Architects
  • Enterprise Data Architects
  • Senior Data Engineers
  • Technical Team Leads
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

  • SQL skills, a background in database management, and, ideally, experience in designing and deploying analytic-based systems are required.
  • Completion of “Snowflake Fundamentals” or equivalent Snowflake knowledge.

Agenda

1 - Architecture Overview

  • Snowflake Architecture
  • Snowflake’s Layered Architecture

2 - Deployment Considerations

  • Organization
  • Geographic Account Considerations
  • Snowflake Security Domains
  • Environment Deployment Options
  • Cross Environment Data Transfer
  • Options
  • Environment Separation
  • Logical Data Architecture (Layers)
  • Physical Architecture Options
  • Database Considerations
  • Database Reference Options
  • Summary and Recommendations

3 - Data Architecture

  • Overall Data Flow
  • Reference Data Architecture
  • Handling Raw History
  • Integration with Data Lake
  • Create External Table
  • Query External Table
  • Partitioned External Tables
  • Snowpipe Streaming Overview
  • External Network Access
  • Native Apps
  • Change Data Capture, Creating and Managing Streams
  • Dynamic Tables
  • Hybrid Tables
  • Iceberg Tables in Snowflake

4 - Virtual Warehouse Management

  • Objectives
  • Workload Challenges
  • Scale Up for Large Workloads
  • Key Concepts: Scaling Up
  • Key Concepts: Diminishing Elapsed Time Improvements
  • Scale Out for Multiple Concurrent Users
  • Speed vs. Throughput
  • Right-Sizing Virtual Warehouses
  • Virtual Warehouse Deployment Approach
  • Measuring Workloads
  • Summary
  • Case Study

5 - Data Security Framework

  • Data Security Framework
  • Data Classification
  • Identify Data Sensitivity

6 - Role-Based Access Control (RBAC)

  • Overview
  • RBAC Requirements
  • RBAC Hierarchy Design
  • RBAC Role Design
  • Naming Standards
  • RBAC Script Building
  • Snowflake RBAC Best Practices

7 - Data Governance Features

  • Data Masking and Row Access Policies
  • Dynamic Data Masking
  • Row Access Policies
  • Summary

8 - Sharing Architecture

  • Use Case
  • Direct Share
  • With Replication
  • Data Mesh
  • Relevant Snowflake Capabilities for a Data Mesh
  • Data Mesh Architecture Options with Snowflake
  • Data Products in Snowflake
  • Auto-fulfillment
  • How Auto-fulfillment Works

9 - Snowflake Data Storage

  • Data Storage Methods
  • Snowflake Data Storage
  • Data Storage Implications
  • Time Travel
  • Key Point
  • Time Travel and Storage
  • Clones
  • Data Recovery
  • Agile Data Management
  • Development
  • System Testing
  • Deployment

10 - Table Clustering

  • What Is Table Clustering?
  • Partition Pruning (Elimination)
  • Overlapping Values
  • Evaluating Clustering
  • Implement and Test Clustering Keys

11 - Performance Optimization

  • Search Optimization
  • How Does It Work?
  • Materialized Views
  • Materialized View Use Cases
  • Query Acceleration Service (QAS)

12 - Management and Observability

  • Observability on Snowflake
  • Outbound Notifications
  • Snowflake Alerts
  • Observability Within Snowsight
  • Budgets
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3606114E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons