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.
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.
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
There are two workshops coming up in August and September 2026. Anyone who works with data is welcome to join!
Snowflake 101: Introduction to Snowflake and Snowflake SQL
When: Thursday, August 20, from 1 p.m. - 4 p.m.
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)
Snowflake 201: Introduction to Snowflake AI Functions and Cortex Code
When: Thursday, September 17, from 1 p.m. - 3 p.m.
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)
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.
Each training will have a custom slide deck shared out at the conclusion of the training, however 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 into the Snowflake window as 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.
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.
Report abuse