Snowflake
Easily access, analyze and manage your centralized state datasets in one secure place.
Embedded Files
One Platform. Flexible by Design.
The OIT Data Operations & Analytics team manages the state's enterprise Snowflake environment by providing onboarding, environment provisioning and flexible service architecture options to help agency teams get started.
Storage & Architecture Options
Data Warehouse | Centralized analytics for structured business data.
Data Lake | Unlimited storage for versatile data types and workloads.
Data Lakehouse | Transactional data lake for unified analytics, AI/ML (machine learning) and collaborative workloads.
Data Mesh/Fabric | Distributed and governed, domain-oriented collaboration.
Build & Analyze, Right in the Platform
Streamlit in Snowflake | Build and deploy interactive data apps and dashboards natively, no separate infrastructure required.
Cortex AI | Native LLM and generative AI functions for search, document analysis, and natural-language querying of your data.
Snowflake Workshops
Quick Summary
The OIT Data Operations & Analytics team hosts regular instructor-led, hands-on training for state employees and contractors.
If you are interested in taking Snowflake training with the OIT Data & Analytics team, please use the signup form.
If there are no training dates listed in the form, please reach out to OIT_SNOWFLAKE_TRAINING@state.co.us to learn when the next training will be.
Schedule
We will update this page when new trainings are planned. Anyone who works with data is welcome to join!
Snowflake 101
About This Course
Snowflake 101 provides a hands-on technical deep dive into the SQL database layer, focusing on architecture and performance for those who build the state's data models.
Best For: Data Analysts and BI Developers who use or will be using Snowflake. Training is open to OIT and non-OIT participants.
Location: Remote (invite will be sent upon form completion)
Each training will have a custom slide deck shared out at the conclusion of the training. This general slide deck can be reviewed to learn about the content that will be discussed.
Previous Recordings
Training Materials
For this course, you will be working in a Snowflake trial account. Please follow the instructions in this guide to create a Snowflake trial account.
For this course, you will be executing code alongside the instructor in Snowflake. Please open this file, copy all of the code content, and paste it into the Snowflake window as we walked through in the training.
Snowflake 201
About This Course:
Snowflake 201 provides a hands-on introduction to AI capabilities within the Snowflake platform, focusing on AI SQL functions and Cortex Code.
Best For: Data Analysts, Data Engineers and AI Architects / Developers who use or will be using Snowflake. Training is open to OIT and non-OIT participants.
Location: Remote (invite will be sent upon form completion)
Each training will have a custom slide deck shared out at the conclusion of the training. A slide deck and previous recording will be shared soon!
Training Materials
For this course, you will be working in a Snowflake trial account. Please follow the instructions in this guide to create a Snowflake trial account.
Free Training Resources for Data Scientists and Data Analysts
Instructor-Led & Structured Courses
Snowflake Practitioner — A brand-new, free, 2-day instructor-led course launching October 5th. It's designed with persona-specific labs for Data Analysts, Data Engineers, and Admins, with AI-powered Cortex Code (CoCo) integrated throughout. Your analysts and data scientists would get hands-on experience in querying, AI functions, data loading, and a capstone project. Enroll on the website.
Snowflake Platform Training — A live, virtual training seminar led by Snowflake instructors covering architecture, data integration and hands-on labs with a curated Snowflake account. Enroll on the website.
More training is available on the website.
Self-Paced Free Resources
Great for Business-Side Analysts!
Hands-On Essentials Badge Track — Free, self-paced workshops with hands-on labs and short videos. Learners earn shareable badges upon completion. Covers data warehousing, data sharing, and data applications. Perfect for analysts new to Snowflake. Enroll on the website.
Level Up: First Concepts Series — Free, on-demand learning track covering foundational Snowflake concepts. A great starting point before diving into the instructor-led courses. Enroll on the website.
Data & AI Fast Track Program — A free, live 6-session series covering practical data and AI skills, including sessions on "The Ultimate Guide to Becoming a Data Analyst" and "Data Storytelling in the Age of Gen AI." Participants receive certificates of completion. Enroll on the website.
How to Sign Up
All courses are available through Snowflake's training portal.
To register:
Visit the link for the course you're interested in.
Create a free Snowflake University account (or log in if you already have one).
Click "Enroll" or "Register" on the course page.
For the Hands-On Essentials, visit snowflake.com/snowflake-essentials-training and follow the prompts.
Report abuse