Learnlytica
Book a demo
← All 186 courses
CL-317 Cloud & Platform

Snowflake Performance, Governance & Cost

Run Snowflake as a production platform where performance, access control and credit consumption are engineered together rather than argued about after the invoice. Learners read query profiles to find spilling and failed pruning, size warehouses from queue evidence, apply masking and row access policies, and cut the credit burn of a deliberately wasteful workload without changing its results.

B4Professional
6modules
42skill atoms
3role journeys
Curriculum

What this course covers.

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

1Micro-partitions and Clustering7 skill atoms
micro-partition metadata and pruningnatural clustering from load ordercluster keys and when they pay for themselvesautomatic clustering credit consumptionreading SYSTEM$CLUSTERING_INFORMATION depthhigh-cardinality cluster key mistakesre-clustering cost after large DML
2Query Profiling and Tuning7 skill atoms
reading the query profile operator treebytes scanned vs partitions prunedspilling to local and remote storageexploding joins and accidental cartesiansresult cache hits and why they misssearch optimization service candidatesmaterialized view vs query rewrite
3Warehouse Sizing and Economics7 skill atoms
credits per size per secondauto-suspend interval vs cache warmthdoubling size halving runtime or notmulti-cluster min and max with scaling policyqueue time as the sizing signalworkload isolation to protect an SLAstatement timeout capping runaway cost
4Resource Monitors and Cost Control7 skill atoms
monitors at account and warehouse levelnotify, suspend and suspend-immediate actionsmonthly quota reset behaviourACCOUNT_USAGE warehouse metering historyattribution by query tag and rolestorage cost from time travel and clonesidle warehouses and forgotten tasks
5RBAC and Data Protection7 skill atoms
role hierarchy split into functional and access rolesownership vs usage grantsfuture grants for newly created objectsdynamic data masking policiesrow access policies driven by an entitlement tablesecure views and secure UDFstag-based policy assignment
6Data Sharing Governance7 skill atoms
secure shares vs copying data outreader accounts for non-Snowflake consumerslistings and private exchangesconsumer-side credit responsibilitymasking that must survive the shareaccess history for share usage auditrevoking a share and its blast radius
Where it fits

CL-317 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.

FinOps Analyst

Professional stage
CL-310→CL-317→CL-502

Data Engineer

Professional stage
CL-406→CL-317→CL-320

Data Cloud Engineer (Snowflake)

Professional stage
CL-311→CL-317→CL-407

Roles this course serves

Data Cloud Engineer (Snowflake)Data EngineerFinOps Analyst
The capability ladder

This course is authored to band B4.

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
B1
AwareUnderstands concepts and vocabulary; uses tools with guidance
Knowledge checks
B2
FoundationPerforms standard tasks correctly in familiar contexts
Guided labs, autograded exercises
B3
PractitionerDelivers complete pieces of work independently
Scenario labs, proctored hands-on exams
B4
ProfessionalHandles production-grade complexity, trade-offs and failure modes
Break-fix drills, design defenses
B5
AdvancedEngineers systems end-to-end under constraints; leads others
Rubric-scored capstones, vivas
B6
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.

Related

Other Cloud courses at this level.

CL-202

AWS Solutions Architecture

B4 · Professional
CL-204

AWS Data Engineering

B4 · Professional
CL-212

Azure Solutions Architecture

B4 · Professional
CL-214

Azure Data Engineering

B4 · Professional
CL-222

Google Cloud Data Engineering Bootcamp

B4 · Professional
CL-223

GCP Architecture & Operations

B4 · Professional
Next step

Run CL-317 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