Snowflake Data Architect Certification Training in Gurgaon
Master Snowflake Cloud and get prepared for Snowflake official certifications with our role based courses tailored to your specific needs
- Enroll for Snowflake Architecture, Developer, Operations, DevOps, AI / ML, and Networking Certifications
- Experience blended learning through interactive offline and online sessions.
- Job Assured Course
- Course Duration - 2 months
- Get Trained from Industry Experts
Train using realtime course materials using online portals & trainer experience to get a personalized teaching experience.
Active interaction in sessions guided by leading professionals from the industry
Gain professionals insights through leading industry experts across domains
Enhance your career with 42+ in-demand skills and 20+ services
Snowflake Data Architect Certification Overview
This Snowflake live-learning courses cover deep into designing, developing, deploying, and managing scalable solutions and infrastructure across Snowflake platform, equipping you for success in today’s fast-evolving technology landscape
- Benefit from ongoing access to all self-paced videos and archived session recordings
- Success Aimers supports you in gaining visibility among leading employers
- Get prepared for 6+ Snowflake official certifications with our role based courses tailored to your specific needs
- Engage with real-world capstone projects
- Engage in live virtual classes led by industry experts, complemented by hands-on projects
- Job interview rehearsal sessions
Demonstrates expertise in designing end-to-end data flows from source to consumption using the Snowflake Platform, creating and deploying data architectures that align with business, security, and compliance requirements. Proficient in selecting optimal Snowflake and third-party tools to enhance architecture performance, as well as designing and deploying shared datasets through the Snowflake Marketplace and Data Exchange
What is Snowflake Data Architect?
Snowflake Certified Data Architect concepts are essential for driving Data innovation in software development and testing. They manage the full deployment lifecycle—deploying apps, building and maintaining pipelines for web applications and K8s workflows, and automating development and testing processes. By streamlining workflows and resolving challenges in webapp deployment on cloud, and maintenance, they help organizations deliver reliable, high-performance applications faster and more efficiently.
The role of Snowflake Cloud Data Architect?
Snowflake Certified Data Architects in data engineering development and testing oversees the end-to-end lifecycle of data applications, from development to deployment and system performance optimization. Key responsibilities include:
Exploring Emerging Technologies: Leveraging Cloud technologies, Cloud networking, and security techniques to enhance efficiency and streamline deployment workflows.
Scalable Data, AI & WebApps Development: Designing and implementing web applications that address critical business needs.
Seamless Deployment: Coordinating web deployment with infrastructure management for smooth delivery.
Workflow Optimization: Creating, analyzing, and refining automation scripts and deployment workflows to maximize productivity.
For professionals aspiring to excel in this field, the Success Aimers Snowflake certified Data Architect Course provides hands-on training to master these skills. The program equips you to confidently manage deployment lifecycles, deployment pipelines, automation, and deployment processes, positioning you as a high-impact Snowflake Certified Data Architect in Data pipeline development and testing.”**
Who should take this Snowflake Certified Data Architect course?
The Snowflake Certified Data Architect course is tailored for professionals aiming to accelerate their careers in Cloud, data, and technology-driven sectors. It is particularly valuable for roles including:
Cloud Team Leaders
Software and DevOps Developers
Cloud Engineers and IT Managers
Cloud & Infrastructure Engineers
Cloud Researchers and Application Engineers
This program equips participants with the skills to lead DevOps & infrastructure initiatives, implement advanced deployment workflows, and drive innovation in Data Pipeline development and testing.
What are the prerequisites of Snowflake Certified Data Architect Course?
Prerequisites for the Snowflake Certified Data Architect Certification Course”
To ensure a seamless learning experience, candidates are expected to have:
Educational Background:Â An undergraduate degree or high school diploma in a relevant field.
Technical Foundation: Knowledge of IT, software development, or data science fundamentals.
Programming Skills:Â Basic proficiency in languages such as Python or JavaScript.
Cloud Familiarity:Â Experience with cloud platforms like AWS or Microsoft Azure.
Meeting these prerequisites enables learners to effectively grasp advanced Cloud concepts, including DevOps tool, Data pipeline workflows, Webapp deployment, and automation throughout the course.
Kind of Job Placement/Offers after Snowflake Certification Course?
- Snowflake Certified Data Engineer
- SRE Reliability Engineer
- Cloud Solutions Release Manager
- Infrastructure/Cloud Automation Engineer
- Cloud Engineer / Cloud Architect
- Cloud Infrastructure Engineer
- Cloud Deployment Engineer
- Â
| Training Options | Weekdays (Mon-Fri) | Weekends (Sat-Sun) | Fast Track |
|---|---|---|---|
| Duration of Course | 2 months | 3 months | 15 days |
| Hours / day | 1-2 hours | 2-3 hours | 5 hours |
| Mode of Training | Offline / Online | Offline / Online | Offline / Online |
Snowflake Data Architect Course Overview
This Snowflake certified Data Architect Certification training enhances your career after choosing the relevant certification path based on the roles. You can practice with hands-on labs and capstone projects and gain proficiency with Snowflake tools. After completion of the course, you can leverage Job assistance services and enhance career prospects.
Architecture
Snowflake Snowpro Advanced Data Architect Course (ARA-C01)
Getting Started & Workspaces UI
- Sign-up for the FREE Snowflake trial
- Navigation Worksheets in Snowsight
- UPDATE TO THE SNOWFLAKE UI-Workspaces
- Workspaces Why?
- LAB-1-PART-1-Using Workspaces-Basics
- LAB-1-PART-2-Using Workspaces-Muti-Workspace Set Up
- LAB-1-PART-3-Using Workspaces-Worksheets in Workspaces
- LAB-1-PART-4-Using Workspaces-SQL Editor Basics
- LAB-1-PART-5-Using Workspaces-Result Window Features
- LAB-1-PART-6-Using Workspaces-Query History
- LAB-1-PART-7-Using Workspaces-Multi-Tab Results Window
- LAB-1-PART-8-Workspaces-Split Results Pane
- LAB-1-PART-9-Workspaces-Split SQL Editor
- LAB-1-PART-10-Using Workspaces-Column Statistics
- LAB-1-PART-11-Using Workspaces-Database Explorer
- LAB-Snowflake AI Copilot
- Snowflake Editions
- Understanding Snowflake Costs?
- Understanding the HR Data Model
- LAB - Populating data into the HR Data Model
Domain 1: Accounts & Security
- Organization, Accounts and Editions
- Account Identifiers
- One Account: benefits vs disadvantages
- Compliance
- Parameters
- Storage Integration
- Replication and Failover
- Public and Private Connection
- Access Control Overview
- System-Defined Roles and Custom Roles
- System-defined Roles (Best Practices)
- Primary and Secondary Roles
- Access Control Commands
- [Hands-On] - Access Control
- Access Control (Best Practices)
- [Hands-On] - Managed Schemas
- Sensitive Data (Best Practices)
- Authentication Overview
- Authentication for Humans
- [Hands-On] Multi-Factor Authentication
- Authentication for Machines - Part 1
- Authentication for Machines - Part 2
- Network Security
- [Hands On] Network Policies
- End-to-End Encryption
- Encryption Key Management
- Secure Data Sharing
- Time Travel
- Secure Views
- Column-level Security
- Cloning
Domain 2: Snowflake Architecture
- Data Modeling with Snowflake
- Data Modeling
- Schema-on-Read and Schema-on-Write
- Marketplace
- Reader Accounts
- Secure Data Sharing - Part 1
- [Hands On] Secure Data Sharing - Listings
- Secure Data Sharing - Part 2
- [Hands On] Secure Data Sharing - Data Exchange
- Secure Data Sharing - Part 3
- Reference Architectures and Development Lifecycles
- Data Recovery - Replication
- [Hands On] Data Recovery - Replication
- Data Recovery - Failover
- Data Recovery
Domain 3: Data Engineering
- Data Ingestion Overview
- Staging
- [Hands On] Create an AWS Account
- [Hands On] Read from AWS with an External Stage
- Staging Data
- Loading Data - Overview
- Bulk Loading
- [Hands On] Bulk Loading
- Continuous Loading
- Snowpipe
- [Hands On] Load with Snowpipe from AWS
- Snowpipe Streaming
- Kafka Connector
- Alternatives of Loading
- Views
- External Functions
- Stored Procedures
- UDF
- Streams
- Tasks
- Streams and Tasks
- Data Processing
- LAB 18-Re-processing failed Rows in the COPY statement.
- LAB 19-Loading Data to Snowflake using the Snowsight Web UI Wizard.
- Data Unloading
- Snow SQL
- ODBC Driver
- JDBC Driver
- SQL API
- Spark Connector
- Python Connector
- Python and Spark Connector
Domain 4: Performance Optimization
- Persisted Query Result
- Search Optimization Service
- Virtual Warehouse
- Scaling Up vs Scaling Out
- ACCOUNT_USAGE and INFORMATION_SCHEMA
- Query Rewrite
- Clustering Keys
Domain 5: Snowflake Features: Loading Patterns, Streams, Tasks, Cloning & Table Types
Storage Integration
- Introduction for Storage Integration
- What is Storage Integration?
- LAB 1-Create Storage Integration
- What is a File Format?
- Understanding File Format Options
- LAB 2-Create CSV file format
- What is a Stage?
- LAB 3-Create Stage
- Section Summary for Storage integration
Loading Data to Snowflake
- Introduction for Loading Data to Snowflake.
- What is Data Latency?
- What are the Loading Types supported in Snowflake?
- Understanding the COPY statement
- What are COPY options?
- LAB 1-Basic COPY to Target Table & COPY OPTION FORCE
- LAB 2-Loading a Subset of Columns with COPY
- LAB 3- COPY OPTION FILES
- LAB 4-COPY OPTION PATTERN
- LAB 5-COPY OPTION PURGE=TRUE
- LAB 6-COPY OPTION TRUNCATECOLUMNS
- LAB 7-COPY OPTION ON_ERROR =ABORT_STATEMENT
- LAB 8-COPY OPTION ON_ERROR =SKIP_FILE
- LAB 9-COPY OPTION ON_ERROR =SKIP_FILE_NUM
- LAB 10-COPY OPTION ON_ERROR =SKIP_FILE_%
- LAB 11-COPY OPTION ON_ERROR =CONTINUE
- LAB 12-COPY OPTION RETURN_FAILED_ONLY
- LAB 13-COPY OPTION SIZE_LIMIT
- LAB 14-COPY OPTION VALIDATION_MODE
- LAB 15-Loading Data overriding the File Format
- LAB 16-Loading Data from s3 to Snowflake without a Stage
- LAB 17-Transforming Data in the COPY statement.
- LAB 18-Re-processing failed Rows in the COPY statement.
- LAB 19-Loading Data to Snowflake using the Snowsight Web UI Wizard.
Loading Semi-Structured Data to Snowflake
- Introduction for Loading Semi-Structured Data
- What is Semi-Structured Data?
- What are the semi-structured data types supported in Snowflake?
- LAB 1-Loading and Selecting data from OBJECT data Type
- LAB 2-Loading and Selecting data from ARRAY data Type
- LAB 3-Loading and Selecting data from VARIANT data Type
- LAB 4-Flattening JSON data with LATERAL FLATTEN-Single Record
- LAB 5-Combining JSON data with UNION ALL & LATERAL FLATTEN-Multiple Record
Snowpipe
- Introduction for Snowpipe
- What is Snowpipe?
- LAB 1-PART-1-Create a Snowpipe
- LAB 1-PART-2-Create a Snowpipe-Setup Event Notifications
- LAB 1-PART-3-Create a Snowpipe-COPY Options
- Troubleshooting Snowpipe Errors
- LAB 2-Fix Snowpipe Errors and Re-Load Data
- Determine Snowpipe Costs
- LAB 3-Snowpipe Costs
- Limitations of Snowpipe
Tasks
- Introduction for Tasks
- What are Tasks?
- Task Features - Part-1
- Task Features - Part-2
- LAB-1 Creating Tasks
- LAB-2 Creating Tasks-NoSchedule
- LAB-3 Creating Tasks-NoWarehouse
- LAB-4 Creating Task-MultiSQL
- LAB-5-Creating Tasks-WHEN Clause
- LAB-6-Creating a Task Tree
- LAB-7-Creating Tasks-Setting Dependencies
- LAB-8-Creating Tasks-Monitoring Tasks
- LAB-9-Creating Tasks-FINALIZE Task
- LAB-10-Creating Tasks-Using MERGE with Tasks
- LAB-11-Creating Tasks-Using COPY with Tasks
Streams
- Introduction for Streams
- What are Streams?
- Different Types of Streams Supported in Snowflake
- LAB 1-Create a STANDARD Stream
- LAB 2-Streams and Tasks to Implement CDC
- LAB 3-Streams with more than 1 Table
- LAB 4-Create a Stream on a View
- LAB 4-Create an APPEND-ONLY- Stream
- LAB 5-How to Empty a Stream.
- LAB 6-Change Tracking
Unloading Data from Snowflake
- Introduction for Unloading Data
- What is Data Unloading?
- Data Unloading Features
- LAB-1-Unloading Data from Snowflake-Format CSV
- LAB-2-COPY OPTIONS: SINGLE|MAX_FILE_SIZE|HEADER|OVERWRITE
- LAB-3-Unloading Data: Multi-Table Unload
- LAB-4-Unloading Data: Partitioned Data Unload
- LAB-5-Unloading Data from Snowflake-Format JSON
- LAB-6-Unloading Data from Snowflake-Format Parquet
Snowflake Internal Stages
- Introduction for Internal Stages
- What is an Internal Stage?
- Types of Internal Stages supported in Snowflake-USER STAGE?
- Types of Internal Stages supported in Snowflake-TABLE STAGE?
- Types of Internal Stages supported in Snowflake-NAMED INTERNAL STAGE?
- What is Snow SQL?
- LAB-1-Installing Snow SQL
- LAB-2-Login to Snowflake using Snow SQL
- LAB-3-Named Internal Stage-PUT
- LAB-4-Named Internal Stage-GET
- LAB-5-Named Internal Stage-REMOVE
- LAB-6-User Stage
- LAB-7-Table Stage
- LAB-8-COPY-Loading Data to & Unloading Data from Internal Stages
Time Travel & Fail-Safe
- Introduction for Time Travel & Fail-Safe
- What is Time Travel?
- LAB 1-Time Travel with SELECT statement
- LAB 2-Time Travel with UNDROP statement
- LAB 3- Turning off Time Travel
- What is Fail-Safe?
- LAB 4-Fail-Safe
Snowflake Table Types
- Introduction for Snowflake Table Types
- What are the Table Types supported in Snowflake?
- What are the Table Types supported in Snowflake-Matrix?
- LAB 1-Create tables in Snowflake
- LAB 2-Impact of Temporary tables on a Permanent table
Zero Copy Cloning
- Introduction for Zero Copy Cloning
- What is Zero Copy Cloning?
- What are the advantages of Zero Copy Cloning?
- Zero Copy Cloning Use Cases
- LAB 2-Impact of Temporary tables on a Permanent table
- Privilege Inheritance in Zero Copy Cloning
- LAB 1-Zero Copy Cloning of Tables
- LAB 2-Zero Copy Cloning of Sequence, File Format, Stages, Streams and Tasks
- LAB 3-Zero Copy Cloning of Databases and Schema
- LAB 4-Zero Copy Cloning with Time Travel
Roles and Access Control
- Introduction for Roles and Access Control
- What is Access Control Framework and why it is needed?
- Key Concepts of Access Control Framework
- Access Control Framework Model
- Types of Roles in Snowflake
- What is a Custom Role?
- LAB 1-PART-1-Create Snowflake Users & Custom Roles
- LAB 1-PART-2-Create Snowflake Users & Custom Roles
- What is Role Hierarchy?
- LAB 2-Create a Role Hierarchy
- Understanding Snowflake Organization and ORGADMIN Role
- LAB 3-Snowflake Organization
- What is a Database Role?
- LAB 4-Create & Grant Database Role
- What are Secondary Roles?
- LAB 5-Enable Secondary Roles
Dynamic Data Masking
- Intro for Dynamic Data Masking
- What is Dynamic Data Masking?
- LAB 1-PART-1-Dynamic Data Masking Implementation
- LAB 1-PART-2-Dynamic Data Masking Implementation
- LAB 1-PART-3-Dynamic Data Masking-UDF Masking
- LAB 1-PART-4-Dynamic Data Masking-Date Masking
- LAB 2-Risks/Dangers of Data Masking
- LAB 3-Data Masking Views
- LAB 4-Conditional Data Masking
Data Sharing
- Introduction for Data Sharing
- What is Data Sharing in Snowflake
- Types of Data Sharing supported in Snowflake
- What is a Snowflake Reader Account?
- LAB 1-PART-1-Data Sharing with Direct Share
- LAB 1-PART-2-Data Sharing with Direct Share
- LAB 2-Data Sharing with Secure Views
- LAB 3-Data Sharing with Reader Accounts
- LAB 4-Data Sharing with Listing
- LAB 5-Partner Connect
- LAB 6-Data Sharing with Snowsight Web UI
Materialized Views
- Introduction for Materialized Views
- What are Materialized Views?
- Understanding limitations of Materialized Views
- LAB 1-Create a Materialized View
- LAB 2-Test limitations of Materialized Views
- LAB 3-Suspend and Resume a Materialized View
- LAB 4-Understand Auto Suspension of Materialized Views
- LAB 5-Analyze credit Consumption by Materialized Views
Performance Tuning & Cost Optimization
- Introduction to Performance Tuning
- What is Data Caching?
- LAB 1-Use the Snowflake Data Cache
- What is Table Partitioning?
- What are Micro-Partitions in Snowflake?
- Clustering Tables in Snowflake?
- LAB 2-Cluster a Snowflake Table
- Why cluster Materialized Views?
- LAB 3-Clustering Materialized Views
- Scale Up VS Scale Out
- LAB 4 -Scaling up and scaling out in Action
- What is a Scaling Policy?
- LAB 5-Create and Modify Scaling Policy
- What is Query Acceleration Service?
- What is Scale Factor?
- LAB 6-Query Acceleration Service
Data Sampling
- Introduction to Data Sampling
- What is Data Sampling?
- Types of Data Sampling supported by Snowflake
- LAB 1-Fixed Row Size Sampling
- LAB 3-SYSTEM/BLOCK Sampling
- LAB 4-Data Sampling with JOINS
- LAB 5-Data Sampling USE CASE with 150 million rows
External Tables
- Introduction for External Tables
- What is a Snowflake External Table?
- LAB 1-PART-1 Create Snowflake External Tables
- LAB 1-PART-2 Create Snowflake External Tables
- Auto Refresh in Snowflake External Tables
- LAB 2 Enabling auto refresh for Snowflake External Tables
- Understanding Snowflake Partitioned External Tables
- LAB 3 Creating partitioned External Tables
- Understanding Snowflake External tables in non-CSV format
- LAB 4 Creating Snowflake External Table with parquet file format
- Snowflake External tables in JSON format
- LAB 5 Creating Snowflake External Tables with JSON file format
- Streams on Snowflake External Tables
- LAB 6 Creating Streams on Snowflake External tables and ingesting them
Dynamic Tables
- Introduction for Dynamic Tables
- What are Dynamic Tables?
- Dynamic Table Refresh
- LAB 1-Create Dynamic Table
- Costs of Dynamic Tables
- Limitations of Dynamic Tables
- Dynamic Table pipelines
- LAB 2 Create Dynamic Table pipelines
- How to monitor Dynamic Tables
- LAB 3-Monitor Dynamic Tables
Event Tables
- Introduction for Event Tables
- What is an Event Table?
- Understanding LOG_LEVEL
- Understanding TRACE_LEVEL
- Event Tables-LAB-PART 1-Create Event Table & Log Events
- Event Tables-LAB-PART 2-Understand Event Table Structure
- Event Tables-LAB-PART 3-Features of Event Tables
- Limitations of Event Tables
- Costs of Event Tables
- LAB 3-Monitor Dynamic Tables
Hybrid Tables
- Introduction for Hybrid Tables
- What is a Hybrid Table?
- LAB-Create Hybrid Tables
- What is Unistore?
- Snowflake Architecture and Hybrid Tables
- Limitations of Hybrid Tables
Iceberg Tables
- Introduction for Snowflake Iceberg Tables
- What is Apache Iceberg?
- Key Features of Apache Iceberg
- LAB 1 Create Iceberg tables in AWS
- What are Snowflake Iceberg tables?
- What is a Data Catalog and why do we care?
- LAB 2 Create Unmanaged Iceberg tables in Snowflake
- LAB 3 Create Managed Iceberg tables in Snowflake
- What is the difference between External Tables and Iceberg tables
Hours of content
Live Sessions
Software Tools
After completion of this training program you will be able to launch your carrer in the world of AI being certified as Snowflake Certified Data Architect course.
With the Snowflake Certified Data Architect Course course in-hand you can boost your profile on Linked, Meta, Twitter & other platform to boost your visibility
- Get your certificate upon successful completion of the course.
- Certificates for each course
- Snowpro
- Snowflake Cloud
- Snowflake SQL
- Snowflake Data Pipeline
- Snowflake Virtual Warehouse
- Snowflake Continuous Ingestion
- Snowflake ML
- Snowflake AI
- Snow SQL
- Snow Park
- Snowflake Kafka Integration
- Snowflake Connectors
- Snowflake Administration
- Snowflake Data Sharing
- Snowflake Cloud
- Snowflake Monitoring
45% - 60%
Designed to provide guidance on current interview practices, personality development, soft skills enhancement, and HR-related questions
Receive expert assistance from our placement team to craft your resume and optimize your Job Profile. Learn effective strategies to capture the attention of HR professionals and maximize your chances of getting shortlisted.
Engage in mock interview sessions led by our industry experts to receive continuous, detailed feedback along with a customized improvement plan. Our dedicated support will help refine your skills until your desired job in the industry.
Join interactive sessions with industry professionals to understand the key skills companies seek. Practice solving interview question worksheets designed to improve your readiness and boost your chances of success in interviews
Build meaningful relationships with key decision-makers and open doors to exciting job prospects in Product and Service based partner
Your path to job placement starts immediately after you finish the course with guaranteed interview calls
Why should you choose to pursue a Snowflake Certified Data Architect Course with Success Aimers?
Success Aimers teaching strategy follow a methodology where in we believe in realtime job scenarios that covers industry use-cases & this will help in building the carrer in the field of Snowflake & also delivers training with help of leading industry experts that helps students to confidently answers questions confidently & excel projects as well while working in a real-world
What is the time frame to become competent as a Snowflake Architect?
To become a successful AWS Engineer required 1-2 years of consistent learning with dedicated 3-4 hours on daily basis.
But with Success Aimers with the help of leading industry experts & specialized trainers you able to achieve that degree of mastery in 6 months or one year or so and it’s because our curriculum & labs we had formed with hands-on projects.
Will skipping a session prevent me from completing the course?
Missing a live session doesn’t impact your training because we have the live recorded session that’s students can refer later.
What industries lead in Snowflake implementation?
- Manufacturing
- Financial Services
- Healthcare
- E-commerce
- Telecommunications
- BFSI (Banking, Finance & Insurance)
- Travel Industry
- Â
Does Success Aimers offer corporate training solutions?
At Success Aimers, we have tied up with 500 + Corporate Partners to support their talent development through online training. Our corporate training programme delivers training based on industry use-cases & focused on ever-evolving tech space.
How is the Success Aimers Snowflake Certified Data Architect Course reviewed by learners?
Our Snowflake Data Architect Course features a well-designed curriculum frameworks focused on delivering training based on industry needs & aligned on ever-changing evolving needs of today’s workforce due to Cloud Computing (Snowflake). Also our training curriculum has been reviewed by alumi & praises the thorough content & real along practical use-cases that we covered during the training. Our program helps working professionals to upgrade their skills & help them grow further in their roles…
Can I attend a demo session before I enroll?
Yes, we offer one-to-one discussion before the training and also schedule one demo session to have a gist of trainer teaching style & also the students have questions around training programme placements & job growth after training completion.
What batch size do you consider for the course?
On an average we keep 5-10 students in a batch to have a interactive session & this way trainer can focus on each individual instead of having a large group
Do you offer learning content as part of the program?
Students are provided with training content wherein the trainer share the Code Snippets, PPT Materials along with recordings of all the batches
Snowflake Certification Training in Gurgaon Master Snowflake cloud and get prepared for Snowflake official certifications...
Snowflake Data Administrator Certification Training in Gurgaon Master Snowflake cloud and get prepared for Snowflake...
Snowflake Data Analyst Certification Training in Gurgaon Master Snowflake Cloud and get prepared for Snowflake...
Snowflake Data Engineer Certification Training in Gurgaon Master Snowflake cloud and get prepared for Snowflake...
Snowflake Data Scientist Certification Training in Gurgaon Master Snowflake cloud and get prepared for Snowflake...
Snowflake Snowpro Core Certification Training in Gurgaon Master Snowflake Cloud and get prepared for Snowflake...
