CL-224 Cloud & Platform

Snowflake Core Engineering

Become productive on Snowflake with an accurate mental model rather than warehouse habits carried over from elsewhere: separated storage and compute, warehouses sized per workload, loading with COPY and Snowpipe, and time travel and cloning used deliberately. Learners build a loading pipeline from stage to modelled tables, recover a bad load with time travel, and clone a database into a test environment.

B3Practitioner

6modules

43skill atoms

3role journeys

Curriculum

What this course covers.

6 modules, 43 named skill atoms. Expand any module to see them.

1Snowflake Architecture7 skill atoms

storage, compute and cloud services layersimmutable micro-partitionsvirtual warehouses independent of storageresult cache vs warehouse local cacheaccount, database and schema hierarchyedition, cloud and region placementwhat the service manages on your behalf

2Virtual Warehouses7 skill atoms

warehouse sizes and credits consumed per hourauto-suspend and auto-resume settingsmulti-cluster warehouses for concurrencyqueued queries vs genuinely slow queriesseparate warehouses per workloadscaling up vs scaling outwarehouse ownership and usage grants

3Loading Data7 skill atoms

internal vs external stagesCOPY INTO with reusable file format objectsSnowpipe auto-ingest from storage eventsfile sizing for parallel loadON_ERROR handling and rejected recordsload metadata preventing duplicate filesbulk backfill vs continuous ingest

4Tables, Stages and Semi-Structured Data7 skill atoms

permanent, transient and temporary tablesVARIANT columns and LATERAL FLATTEN on JSONexternal tables over existing filesIceberg tables and their trade-offsnatural clustering from load orderfile formats reused across pipelinesstorage cost of transient vs permanent tables

5Time Travel and Cloning7 skill atoms

retention windows by table typeUNDROP and AT or BEFORE querieszero-copy clone of a database for testfail-safe as a support-only recovery windowclone storage cost as data divergesrecovering a bad load without a full reloadretention settings weighed against the storage bill

6Snowflake CLI and Modelling Basics8 skill atoms

Snowflake CLI (snow) connections and named profileskey-pair auth for service users and MFA for human users under the 2026 enforcementrole and warehouse set in the sessiondimensional modelling without indexessurrogate keys and slowly changing dimensionsviews vs materialized views and their coststreams and tasks for incremental pipelinesquery tags for later attribution

Where it fits

CL-224 in the role journeys.

This course appears in 3 of our 45 role journeys. Here is what a learner takes immediately before and after it in each.

Data Platform Engineer

Practitioner stage

CL-311→CL-224→CL-406

Data Engineer

Practitioner stage

CL-312→CL-224→CL-225

Data Cloud Engineer (Snowflake)

Practitioner stage

AI-105→CL-224→CL-311

Roles this course serves

Data Cloud Engineer (Snowflake)Data Engineer Data Platform Engineer

The capability ladder

This course is authored to band B3.

Every course we run is written to one rung of the CASI ladder, so a plan can be assembled to take a team from where they are to where they need to be.

What do B1–B6 mean?The CASI Capability Ladder — click to expand

Every course targets a band on the CASI Capability Ladder — our six-band proficiency scale, anchored to open standards (O*NET, ESCO, NICE, NIST AI RMF, Bloom's). A band tells you how deep a course goes, and what evidence proves it.

What the learner can doTypical evidence

AwareUnderstands concepts and vocabulary; uses tools with guidance

Knowledge checks

FoundationPerforms standard tasks correctly in familiar contexts

Guided labs, autograded exercises

PractitionerDelivers complete pieces of work independently

Scenario labs, proctored hands-on exams

ProfessionalHandles production-grade complexity, trade-offs and failure modes

Break-fix drills, design defenses

AdvancedEngineers systems end-to-end under constraints; leads others

Rubric-scored capstones, vivas

ExpertSets direction; recognised authority across teams

Portfolio + panel evaluation

A note on B6. Courses in this catalog target B1–B5. B6 is not taught — it is recognised, through a portfolio and a panel, once someone is setting direction for others. Every journey here is built to land a learner at B5.

Other Cloud courses at this level.

CL-107

Run CL-224 for your team.

This course runs at several lengths depending on how deep you need to go and how much of it your people already have. Tell us who is being trained and we will scope it.

Add it to a training plan Talk to our team Check your team’s level free

Snowflake Core Engineering

What this course covers.

CL-224 in the role journeys.

Data Platform Engineer

Data Engineer

Data Cloud Engineer (Snowflake)

Roles this course serves

This course is authored to band B3.

Other Cloud courses at this level.

PostgreSQL for Cloud Engineers

Serverless Engineering on AWS (Lambda · DynamoDB)

Analytics Engineering with dbt

Enterprise BI with Power BI & Tableau

Workflow Orchestration with Airflow

Kubernetes Administration

Run CL-224 for your team.