Skip to main content
MindLeap AI MindLeap AI
Advanced Level

Snowflake SnowPro Advanced Data Architect Certification (ARA-C01)

Design resilient multi-cloud Snowflake architectures with advanced data sharing, Iceberg pipelines, and enterprise security for the ARA-C01 exam.

★ 4.8 (300 learners) 60 hrs total 27 modules 3 capstones
AWS Apache Spark Snowflake Snowpipe Python
Only 6 seats left · Next batch starts 22 Aug 2026
Download Curriculum
60 hrs
of content
27 modules
in curriculum
19 projects
hands-on builds
Advanced
difficulty

Curriculum covers

Frameworks you'll master

5 tools & frameworks
AWS Apache Spark Snowflake Snowpipe Python

Course Curriculum

27 modules · 60 hours · 24 live sessions

Create a Snowflake Account 1 sessions
  • Handson: Create a Snowflake account
Domain 1: Accounts & Security 2 sessions
  • 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
  • SystemDefined Roles and Custom Roles
  • Systemdefined Roles (Best Practices)
  • Primary and Secondary Roles
  • Access Control Commands
  • [HandsOn] Access Control
  • Access Control (Best Practices)
  • [HandsOn] Managed Schemas
  • Sensitive Data (Best Practices)
  • Authentication Overview
  • Authentication for Humans
  • [HandsOn] MultiFactor Authentication
  • Authentication for Machines Part 1
  • Authentication for Machines Part 2
  • Network Security
  • [Hands On] Network Policies
  • EndtoEnd Encryption
  • Encryption Key Management
  • Secure Data Sharing
  • Time Travel
  • Secure Views
  • Columnlevel Security
  • Cloning
Domain 2: Snowflake Architecture 1 sessions
  • Data Modeling with Snowflake
  • Data Modeling
  • SchemaonRead and SchemaonWrite
  • 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 3 sessions
  • 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
  • [Hands On] Streams
  • Tasks
  • Streams and Tasks
  • Data Processing
  • SemiStructured Data
  • [Hands On] SemiStructured Data
  • Data Unloading
  • [Hands On] Data Unloading
  • Snow SQL
  • [Hands On] Snow SQL
  • ODBC Driver
  • JDBC Driver
  • SQL API
  • Spark Connector
  • Python Connector
  • Python and Spark Connector
Domain 4: Performance Optimization 1 sessions
  • Persisted Query Result
  • Search Optimization Service
  • Virtual Warehouse
  • Scaling Up vs Scaling Out
  • ACCOUNT_USAGE and INFORMATION_SCHEMA
  • Query Rewrite
  • Clustering Keys
Storage Integration 1 sessions
  • Introduction for Storage Integration.
  • What is Storage Integration?
  • LAB 1Create Storage Integration.
  • What is a File Format?
  • Understanding File Format Options.
  • LAB 2Create CSV file format.
  • What is a Stage?
  • LAB 3Create Stage
  • Section Summary for Storage integration
Loading Data to Snowflake 2 sessions
  • Section 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 1Basic COPY to Target Table & COPY OPTION FORCE
  • LAB 2Loading a Subset of Columns with COPY.
  • LAB 3 COPY OPTION FILES
  • LAB 4COPY OPTION PATTERN
  • LAB 5COPY OPTION PURGE=TRUE
  • LAB 6COPY OPTION TRUNCATECOLUMNS.
  • LAB 7COPY OPTION ON_ERROR =ABORT_STATEMENT.
  • LAB 8COPY OPTION ON_ERROR =SKIP_FILE.
  • LAB 9COPY OPTION ON_ERROR =SKIP_FILE_NUM
  • LAB 10COPY OPTION ON_ERROR =SKIP_FILE_%
  • LAB 11COPY OPTION ON_ERROR =CONTINUE.
  • LAB 12COPY OPTION RETURN_FAILED_ONLY.
  • LAB 13COPY OPTION SIZE_LIMIT.
  • LAB 14COPY OPTION VALIDATION_MODE.
  • LAB 15Loading Data overriding the File Format.
  • LAB 16Loading Data from s3 to Snowflake without a Stage.
  • LAB 17Transforming Data in the COPY statement.
  • LAB 18Reprocessing failed Rows in the COPY statement.
  • LAB 19Loading Data to Snowflake using the Snowsight Web UI Wizard.
Loading SemiStructured Data to Snowflake 1 sessions
  • Introduction for Loading SemiStructured Data.
  • What is SemiStructured Data?
  • What are the semistructured data types supported in Snowflake?
  • LAB 1Loading and Selecting data from OBJECT data Type.
  • LAB 2Loading and Selecting data from ARRAY data Type.
  • LAB 3Loading and Selecting data from VARIANT data Type.
  • LAB 4Flattening JSON data with LATERAL FLATTENSingle Record.
  • LAB 5Combining JSON data with UNION ALL & LATERAL FLATTENMultiple Record
Snowpipe 1 sessions
  • Introduction for Snowpipe
  • What is Snowpipe?
  • LAB 1PART1Create a Snowpipe
  • LAB 1PART2Create a SnowpipeSetup Event Notifications
  • LAB 1PART3Create a SnowpipeCOPY Options.
  • Troubleshooting Snowpipe Errors.
  • LAB 2Fix Snowpipe Errors and ReLoad Data.
  • Determine Snowpipe Costs.
  • LAB 3Snowpipe Costs
  • Limitations of Snowpipe.
Tasks 1 sessions
  • Introduction for Tasks.
  • What are Tasks?
  • Task Features Part1
  • Task Features Part2
  • LAB1 Creating Tasks
  • LAB2 Creating TasksNoSchedule
  • LAB3 Creating TasksNoWarehouse
  • LAB4 Creating TaskMultiSQL
  • LAB5Creating TasksWHEN Clause
  • LAB6Creating a Task Tree
  • LAB7Creating TasksSetting Dependencies
  • LAB8Creating TasksMonitoring Tasks
  • LAB9Creating TasksFINALIZE Task
  • LAB10Creating TasksUsing MERGE with Tasks
  • LAB11Creating TasksUsing COPY with Tasks
Streams 1 sessions
  • Introduction for Streams.
  • What are Streams?
  • Different Types of Streams Supported in Snowflake.
  • LAB 1Create a STANDARD Stream
  • LAB 2Streams and Tasks to Implement CDC
  • LAB 3Streams with more than 1 Table
  • LAB 4Create a Stream on a View.
  • LAB 4Create an APPENDONLY Stream
  • LAB 5How to Empty a Stream.
  • LAB 6Change Tracking
Unloading Data from Snowflake 1 sessions
  • Introduction for Unloading Data
  • What is Data Unloading?
  • Data Unloading Features
  • LAB1Unloading Data from SnowflakeFormat CSV
  • LAB2COPY OPTIONS: SINGLE|MAX_FILE_SIZE|HEADER|OVERWRITE
  • LAB3Unloading Data: MultiTable Unload
  • LAB4Unloading Data: Partitioned Data Unload
  • LAB5Unloading Data from SnowflakeFormat JSON
  • LAB6Unloading Data from SnowflakeFormat Parquet
Snowflake Internal Stages 1 sessions
  • Introduction for Internal Stages
  • What is an Internal Stage?
  • Types of Internal Stages supported in SnowflakeUSER STAGE?
  • Types of Internal Stages supported in SnowflakeTABLE STAGE?
  • Types of Internal Stages supported in SnowflakeNAMED INTERNAL STAGE?
  • What is Snow SQL?
  • LAB1Installing Snow SQL
  • LAB2Login to Snowflake using Snow SQL
  • LAB3Named Internal StagePUT
  • LAB4Named Internal StageGET
  • LAB5Named Internal StageREMOVE
  • LAB6User Stage
  • LAB7Table Stage
  • LAB8COPYLoading Data to & Unloading Data from Internal Stages
Time Travel & FailSafe 1 sessions
  • Introduction for Time Travel & FailSafe
  • What is Time Travel?
  • LAB 1Time Travel with SELECT statement
  • LAB 2Time Travel with UNDROP statement
  • LAB 3 Turning off Time Travel
  • What is FailSafe?
  • LAB 4FailSafe
Snowflake Table Types 1 sessions
  • Introduction for Snowflake Table Types
  • What are the Table Types supported in Snowflake?
  • What are the Table Types supported in SnowflakeMatrix?
  • LAB 1Create tables in Snowflake
  • LAB 2Impact of Temporary tables on a Permanent table
Zero Copy Cloning 1 sessions
  • Introduction for Zero Copy Cloning
  • What is Zero Copy Cloning?
  • What are the advantages of Zero Copy Cloning?
  • Zero Copy Cloning Use Cases.
  • Privilege Inheritance in Zero Copy Cloning.
  • LAB 1Zero Copy Cloning of Tables
  • LAB 2Zero Copy Cloning of Sequence, File Format, Stages, Streams and Tasks
  • LAB 3Zero Copy Cloning of Databases and Schema.
  • LAB 4Zero Copy Cloning with Time Travel.
Roles and Access Control 1 sessions
  • 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 1PART1Create Snowflake Users & Custom Roles.
  • LAB 1PART2Create Snowflake Users & Custom Roles.
  • What is Role Hierarchy?
  • LAB 2Create a Role Hierarchy.
  • Understanding Snowflake Organization and ORGADMIN Role.
  • LAB 3Snowflake Organization.
  • What is a Database Role?
  • LAB 4Create & Grant Database Role
  • What are Secondary Roles?
  • LAB 5Enable Secondary Roles.
Dynamic Data Masking 1 sessions
  • Intro for Dynamic Data Masking
  • What is Dynamic Data Masking?
  • LAB 1PART1Dynamic Data Masking Implementation.
  • LAB 1PART2Dynamic Data Masking Implementation.
  • LAB 1PART3Dynamic Data MaskingUDF Masking
  • LAB 1PART4Dynamic Data MaskingDate Masking
  • LAB 2Risks/Dangers of Data Masking
  • LAB 3Data Masking Views
  • LAB 4Conditional Data Masking
Data Sharing 1 sessions
  • Introduction for Data Sharing
  • What is Data Sharing in Snowflake
  • Types of Data Sharing supported in Snowflake.
  • What is a Snowflake Reader Account?
  • LAB 1PART1Data Sharing with Direct Share
  • LAB 1PART2Data Sharing with Direct Share
  • LAB 2Data Sharing with Secure Views
  • LAB 3Data Sharing with Reader Accounts
  • LAB 4Data Sharing with Listing
  • LAB 5Partner Connect
  • LAB 6Data Sharing with Snowsight Web UI
Materialized Views 1 sessions
  • Introduction for Materialized Views.
  • What are Materialized Views?
  • Understanding limitations of Materialized Views.
  • LAB 1Create a Materialized View
  • LAB 2Test limitations of Materialized Views
  • LAB 3Suspend and Resume a Materialized View
  • LAB 4Understand Auto Suspension of Materialized Views
  • LAB 5Analyze credit Consumption by Materialized Views
Performance Tuning & Cost Optimization 1 sessions
  • Introduction to Performance Tuning.
  • What is Data Caching?
  • LAB 1Use the Snowflake Data Cache
  • What is Table Partitioning?
  • What are MicroPartitions in Snowflake?
  • Clustering Tables in Snowflake?
  • LAB 2Cluster a Snowflake Table.
  • Why cluster Materialized Views?
  • LAB 3Clustering Materialized Views
  • Scale Up VS Scale Out
  • LAB 4 Scaling up and scaling out in Action
  • What is a Scaling Policy?
  • LAB 5Create and Modify Scaling Policy
  • What is Query Acceleration Service?
  • What is Scale Factor?
  • LAB 6Query Acceleration Service.
Data Sampling 1 sessions
  • Introduction to Data Sampling.
  • What is Data Sampling?
  • Types of Data Sampling supported by Snowflake
  • LAB 1Fixed Row Size Sampling
  • LAB 2ROW/BERNOULLI Sampling
  • LAB 3SYSTEM/BLOCK Sampling
  • LAB 4Data Sampling with JOINS
  • LAB 5Data Sampling USE CASE with 150 million rows
External Tables 1 sessions
  • Introduction for External Tables
  • What is a Snowflake External Table?
  • LAB 1PART1 Create Snowflake External Tables
  • LAB 1PART2 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 nonCSV 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 1 sessions
  • Introduction for Dynamic Tables
  • What are Dynamic Tables?
  • Dynamic Table Refresh
  • LAB 1Create 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 3Monitor Dynamic Tables
Event Tables 1 sessions
  • Introduction for Event Tables
  • What is an Event Table?
  • Understanding LOG_LEVEL
  • Understanding TRACE_LEVEL
  • Event TablesLABPART 1Create Event Table & Log Events
  • Event TablesLABPART 2Understand Event Table Structure
  • Event TablesLABPART 3Features of Event Tables
  • Limitations of Event Tables
  • Costs of Event Tables
Hybrid Tables 1 sessions
  • Introduction for Hybrid Tables
  • What is a Hybrid Table?
  • LABCreate Hybrid Tables
  • What is Unistore?
  • Snowflake Architecture and Hybrid Tables
  • Limitations of Hybrid Tables
Iceberg Tables 1 sessions
  • 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

After this course, you will

Skills you carry to every job

  • Design multi-cloud Snowflake architectures spanning AWS accounts, multi-region topologies, and cross-cloud replication
  • Implement secure data sharing, Marketplace listings, and reader accounts at enterprise scale
  • Architect continuous ingestion pipelines using Snowpipe, Snowpipe Streaming, and Kafka connectors
  • Build automated data workflows combining Streams, Tasks, Dynamic Tables, and stored procedures
  • Apply advanced security patterns including column-level masking, row access policies, and network policies
  • Optimise data architecture for performance using clustering keys, materialized views, and query acceleration
  • Integrate Snowflake with Apache Spark and Python connectors for external data processing workflows
  • Architect disaster recovery strategies using cross-region database replication and failover promotion

Hands-on learning

What you'll build

3 industry capstone projects · built from scratch · yours to keep

01

Multi-Account Secure Data Sharing Architecture

Design and implement a Snowflake sharing architecture where a central provider account publishes governed datasets via secure listings to multiple consumer accounts. Apply secure views, column-level masking, and provision a reader account for external partners who do not have a Snowflake subscription.

Snowflake AWS
02

Real-Time CDC Pipeline with Snowpipe and Streams

Build an end-to-end change data capture pipeline by ingesting streaming events from AWS S3 via Snowpipe, capturing row-level changes with STANDARD Streams, and processing them with a task tree running MERGE statements into target tables with full monitoring and error handling.

Snowflake Snowpipe AWS
03

Iceberg Data Lakehouse Architecture on AWS

Architect a hybrid Snowflake-Iceberg data lakehouse on AWS: create managed and unmanaged Iceberg tables backed by an S3 external volume, query Iceberg data from Snowflake, and benchmark query performance and cost vs native Snowflake tables using the Query Profile tool.

Snowflake AWS Apache Spark Python

Plus 16 guided mini-projects across the curriculum — Q&A bots, resume screeners, SQL helpers, and more.

Batch Schedule

⚡ Seats filling fast — only 6 remaining across all batches

Available Batches
Batch Type Schedule Duration Next Start Date Availability
Weekend Sat & Sun, 10am–1pm 10 weeks 22 Aug 2026 Available
Weekday Mon–Fri, 7–9pm 8 weeks 24 Aug 2026 Available
Fast-track Mon–Sun, 6 hours/day 2 weeks 31 Aug 2026 Available

Frequently Asked Questions

What is the ARA-C01 exam and who is it designed for?

ARA-C01 is the SnowPro Advanced: Architect certification exam. It targets experienced data engineers and architects who design and manage complex Snowflake environments involving multi-cloud deployments, advanced security architecture, and large-scale data sharing.

How does this course differ from the Data Engineer certification course?

The Architect course focuses on system design decisions — multi-account topology, security architecture, sharing patterns, and reference architectures — while the Data Engineer course focuses on hands-on pipeline construction using Snowpipe, Iceberg tables, and streams and tasks.

What is zero-copy cloning and why is it architecturally significant?

Zero-copy cloning creates an instant copy of a table, schema, or database without duplicating the underlying data — only changes after the clone consume additional storage. This enables non-disruptive dev and test environment creation and point-in-time snapshots at near-zero cost.

How does Snowflake handle cross-cloud database replication?

Snowflake's database replication and failover feature asynchronously replicates data across accounts in different cloud regions or providers. You can promote a secondary account to primary with a single command, enabling business continuity across cloud boundaries.

Is Apache Spark integration covered in depth?

The course covers the Snowflake Spark Connector for reading and writing Snowflake data from Spark pipelines. The focus is on architecture patterns — when to use Spark vs Snowpark for data processing — rather than deep Spark internals.

Does the course cover data mesh architecture patterns?

Yes. The Architecture domain covers reference architectures including data mesh topology using multiple Snowflake accounts for domain ownership, governed sharing via the Marketplace, and centralised governance with decentralised data access and producer-consumer contracts.

Ready to Get Started?

Download the curriculum to see every module, batch dates and fees. Book a free 30-minute session with our advisors to get your questions answered.

Book Free Demo

Download the Full Curriculum

See every module, capstone project, and tool covered — free, instant access.

Similar Courses You Might Like

View Course →
Snowflake
snowflake

Snowflake SnowPro Advanced Data Admin Certification Exam

★ 4.8 · 300 learners · Advanced
Starts 8 Aug 2026 · ~1–2 months
View Course →
Snowflake
snowflake

Snowflake SnowPro Advanced Data Analyst Certification

★ 4.8 · 300 learners · Advanced
Starts 15 Aug 2026 · ~1–2 months
View Course →
Snowflake
snowflake

Snowflake SnowPro Advanced Data Engineer Certification Exam

★ 4.8 · 300 learners · Advanced
Starts 29 Aug 2026 · ~1–2 months
View Course →
Snowflake
snowflake

Snowflake SnowPro Advanced Data Scientist Certification Exam

★ 4.8 · 300 learners · Advanced
Starts 5 Sept 2026 · ~1–2 months
Book Free Demo