Snowflake Architect Training Logo

Snowflake Architect Training

Live Online & Classroom Enterprise Training

Snowflake Architect focuses on designing scalable, secure, and high-performance data architectures on the Snowflake Data Cloud. It equips learners to make end-to-end architectural decisions for enterprise data platforms, from ingestion to analytics and governance.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Snowflake Architect Training about?

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

What are the objectives of Snowflake Architect Training ?

  • This three‐day course for Architects and Technical Leaders provides the skills, knowledge, and Snowflake Examine the trade-offs 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‐recommended best practices to maximize performance and efficient use of resources during data ingestion, transformation, and end user queries.
  • Analyses Snowflake metadata to identify performance and cost issues and recommend remedial action.
  • Real‐world customer experiences, and the confidence to get the most out of Snowflake’s technology.

Who is Snowflake Architect Training for?

  • Solution Architects
  • Data Architects
  • Database Architects
  • Enterprise Data Architects
  • Senior Data Engineers
  • Technical Team Leads

What are the prerequisites for Snowflake Architect Training?

  • Recommended completion of the “Snowflake Multi‐Factor Authentication (MFA) Essentials” free on‐demand course.
  • Completion of “Snowflake Fundamentals” or equivalent Snowflake knowledge.
  • SQL skills, a background in database management, and, ideally, experience in designing and deploying analytics‐based systems are required.

Available Training Modes

Live Online Training

3 Days

Classroom Training

3 Days

Course Outline Expand All

Expand All

  • Snowflake Architecture
  • Snowflake’s Layered Architecture
  • Organization
  • Geographic Account Considerations
  • Snowflake Security Domains
  • Environment Deployment Options
  • Cross Environment Data Transfer
  • Data Transfer Options
  • Environment Separation
  • Logical Data Architecture (Layers)
  • Physical Architecture Options
  • Database Considerations
  • Database Reference Options
  • Summary and Recommendations
  • Overall Data Flow
  • Reference Data Architecture
  • Handling Raw History
  • Integration With a Data Lake
  • Create External Table
  • Query External Table
  • Partitioned External Tables
  • External Network Access
  • Change Data Capture, Creating and Managing Streams
  • Snow pipe Streaming Overview
  • Dynamic Tables
  • Hybrid Tables
  • Apache Iceberg™ Tables in Snowflake
  • Apache Polaris™ and Snowflake Open Catalog
  • Objectives
  • Workload Challenges
  • Scale Up for Large Workloads
  • Key Concepts: Diminishing Elapsed Time Improvements
  • Scale Out for Multiple Concurrent Users
  • Right‐Sizing Virtual Warehouses
  • Virtual Warehouse Deployment Approach
  • Measuring Workloads
  • Summary
  • What is a Container?
  • Use Cases
  • Why Snowflake for AI/ML
  • Incorporating into the Batch Cycle
  • Benefits
  • Data Security Framework
  • Data Classification
  • Identify Data Sensitivity
  • Overview
  • RBAC Requirements
  • RBAC Hierarchy Design
  • RBAC Role Design
  • Naming Standards
  • RBAC Script Building
  • Snowflake‐recommended RBAC Best Practices
  • Snowflake User‐based Access Control (UBAC)
  • Data Masking and Row Access Policies
  • Dynamic Data Masking
  • Row Access Policies
  • Summary
  • Use Case
  • Direct Share
  • With Replication
  • Data Products in Snowflake
  • Auto‐fulfilment
  • How Auto‐fulfilment Works
  • Native Apps
  • Native Apps Demo
  • Data Storage Standard Tables
  • Data Storage Hybrid Tables
  • Snowflake Data Storage Management
  • Data Storage Implications
  • Data Storage DML Implications
  • Time Travel
  • KeyPoint
  • Clones
  • Data Recovery
  • Agile Data Management
  • Development
  • System Testing
  • Deployment
  • What is Table Clustering?
  • Partition Pruning (Elimination)
  • Overlapping Values
  • Evaluating Clustering
  • Implement and Test Clustering Keys
  • Search Optimization
  • How Does It Work?
  • Materialized Views
  • Materialized View Use Cases
  • Query Acceleration Service (QAS)

Who is the instructor for this training?

The trainer for this Snowflake Architect Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews