Challenge Index

Challenge	Topic	dbt Friendly*
Week 39 – Basic	CLS	❌
Week 38 – Basic	Streams	❌
Week 37 – Intermediate	Unstructured Data	✅
Week 36 – Intermediate	Stored Procedure	❌
Week 35 – Intermediate	External Tables	❌
Week 34 – Intermediate	Data Structuring	✅
Week 33 – Hard	Multiple	❌
Week 32 – Basic	Session Security	❌
Week 31 – Basic	MIN_BY, MAX_BY	✅
Week 30 – Intermediate	SnowSQL & Scripting	❌
Week 29 – Intermediate	Snowpark	✅
Week 28 – Intermediate	Marketplace & Ranking	✅
Week 27 – Basic	SELECT EXCLUDE & RENAME	✅
Week 26 – Intermediate	Tasks & Email	❌
Week 25 – Basic	JSON	✅
Week 24 – Intermediate	Snowpark & Streamlit	❌
Week 23 – Basic	SnowSQL	❌
Week 22 – Basic	RLS	✅
Week 21 – Basic	Pivoting	✅
Week 20 – Hard	Stored Procedures	✅
Week 19 – Basic	Dates	✅
Week 18 – Hard	Snowpark	❌
Week 17 – Intermediate	Spatial	✅
Week 16 – Intermediate	JSON	✅
Week 15 – Intermediate	UDFs	✅
Week 14 – Basic	JSON	✅
Week 13 – Intermediate	Last not null	✅
Week 12 – Intermediate	Streamlit	❌
Week 11 – Basic	Tasks	✅
Week 10 – Hard	Stored Procedures	✅
Week 9 – Intermediate	Tags, Masking Policies	✅
Week 8 – Basic	Streamlit	❌
Week 7 – Intermediate	Tags, Account Usage	✅
Week 6 – Hard	Geospatial	✅
Week 5 – Basic	UDFs	✅
Week 4 – Hard	JSON	✅
Week 3 – Basic	Metadata Queries	✅
Week 2 – Intermediate	Streams	✅
Week 1 – Basic	External Stages	✅

* dbt (Data Build Tool) is an ELT tool that works incredibly well with any data transformation job in Snowflake, and is also capable of doing some maintenance tasks. Some Frosty Friday participants enjoy using dbt to solve challenges, and this flag simply tells those participants whether the challenge allows that, or not. Using dbt to solve challenges is entirely optional and is not a requirement.

If you haven’t already, sign up on the right and we’ll email you each time we launch a new challenge!