Snowflake Architect Training
This three-day course for Architects and Technical Leaders provides the skills, knowledge, and Snowflake best practices to deploy and operate Snowflake, insights and recommendations based upon real-world customer experiences, and the confidence to get the very best out of Snowflake’s technology.
In this course, you will:
- Examine the tradeos associated with the available environment and Snowflake Account deployment options.
- Use the Snowflake data security framework to balance the oen-conflicting needs of protecting sensitive data while democratizing access and facilitating sharing.
- Apply Snowflake best practices to maximize performance and eicient use of resources during data ingestion, transformation, and end user queries.
- Analyze Snowflake metadata to identify performance and cost issues and recommend remedial action
This course is intended for:
- Solution Architects
- Data Architects
- Database Architects
- Enterprise Data Architects
- Senior Data Engineers
- Technical Team Leads
We recommend that attendees of this course have:
- SQL skills, a background in database management, and, ideally, experience in designing and deploying analytic-based systems are required.
- Completion of (or equivalent experience): “Snowflake Fundamentals”
Module 1: Architecture Overview
- Workload Challenges
- Database Options
- Snowflake’s Layered Architecture
- Scale Up for Large Workloads
- Speed vs. Throughput
- Scale Out for Multiple Concurrent Users
Module 2: Deployment Considerations
- Organization
- Geographic Account Considerations
- Snowflake Security Domains
- Environment Deployment Options
- Cross Environment Data Transfer
- Options
- Environment Separation
- Logical
Module 3: Data Architecture (Layers)
- Physical Architecture Options
- Database Considerations
- Database Reference Options
- Summary and Recommendations 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
- Change Data Capture, Creating and Managing Streams
- Dynamic Tables
Module 4: Sharing Architecture
- Data Mesh
- Relevant Snowflake Capabilities for a Data Mesh
- Data Mesh Architecture Options with Snowflake
- Data Products in Snowflake
- Auto-Fulfillment Overview and Example
- How Auto-Fulfillment Works
Module 5: Data Security Framework
- Data Security Framework
- Data Classification
- Identify Data Sensitivity R
Module 6: Role-Based Access Control (RBAC)
- Overview
- RBAC Requirements
- RBAC Hierarchy Design
- RBAC Role Design
- Naming Standard
- RBAC Script Building
- RBAC Snowflake Best Practices
Module 7: Data Governance Features
- Data Masking and Row Access Policies
- Dynamic Data Masking
- Row Access Policies
Module 8: 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
Module 9: Table Clustering
- What Is Table Clustering?
- Partition Pruning (Elimination)
Module 10: Virtual Warehouse Deployment Strategy
- Objectives
- Key Concepts: Scaling Up
- Key Concepts: Diminishing Elapsed Time Improvements
- Right-Sizing Virtual Warehouses
- Virtual Warehouse Deployment Approach
- Measuring Workloads
- Case Study
Module 11: Performance Optimization
- Search Optimization
- How Does It Work?
- Materialized Views
- Materialized View Use Cases
- Query Acceleration Service (QAS)
Module 12: Management and Observability
- Observability on Snowflake
- Outbound Notifications
- Snowflake Alerts
- Observability Within Snowsight
- Budgets
Class Deliverables
- E-Content kit by AWS
- Hands-on labs
- Class completion certificates
- Exam Prep sessions
Class Schedule
Stay ahead with our comprehensive course schedule. Browse upcoming training sessions & reserve your spot to gain hands-on expertise & certification-ready skills.
| Virtual | 3 days | All Day | June 4, 2024 | ₹0 | |
| Virtual | 3 days | All Day | June 18, 2024 | ₹0 | |
| Virtual | 3 days | All Day | July 2, 2024 | ₹0 | |
| Virtual | 3 days | All Day | July 16, 2024 | ₹0 |
FAQs
Find answers to commonly asked questions about our courses, certifications, schedules, and more.
Your cloud learning journey made simple and transparent.
To enroll in this course, choose the starting date and make an online payment. Once your payment is confirmed, our team will reach out to you.
Wire Transfer, Credit Card, Debit Card, UPI & Purchase Order.
There is no minimum number of candidates required, we are happy to train 1 to 1 . With regards to the maximum number, we can accomodate 30 learners in one batch.
- Training Delivered by an Amazon Authorized Instructor.
- AWS Content E-Kit
- Hands-on-labs for 30 days
- Class attendance certificate
You will get the access to course content & lab on first day of your training session.
The course Completion Certificate will be issued to your email id within 2 weeks of completing your course.
A one-day course could be delivered over two half day sessions (4 hours a day), or a three-day course could be delivered over five days (4 hours a day)
