Challenge Index

Challenge	Topic	dbt Friendly*
Week 90 – Intermediate	Cortex	❌
Week 89 – Easy	Budgets	❌
Week 88 – Intermediate	Data Governanace	✅
Week 87 – Basic	Cortex	✅
Week 86 – Difficult	Aggregation policy	❌
Week 85 – Intermediate	ASOF Joins	✅
Week 84 – Basic	Staging	❌
Week 83 – Basic	Qualify	✅
Week 82 – Basic	Staging Files	❌
Week 81 – Intermediate	TASK DAGs	❌
Week 80 – Basic	Create table from file	❌
Week 79 – Basic	Login Screen Security	❌
Week 78 – Basic	Session Variables	✅
Week 77 – Hard	Geospatial data	✅
Week 76 – Intermediate	Tasks	✅
Week 75 – Hard	Native App Permissions	❌
Week 74 – Intermediate	Data formats	✅
Week 73 – Intermediate	Interconnected Data	✅
Week 72 – Basic	Execute Immediate	❌
Week 71 – Intermediate	Arrays	✅
Week 70 – Intermediate	Cost Optimization	✅
Week 69 – Intermediate	Snowflake Mystery Functions	✅
Week 68 – Intermediate	SiS	❌
Week 67 – Intermediate	UDF & Objects	✅
Week 66 – Intermediate	Snowpark	✅
Week 65 – Basic	UDF & Marketplace	✅
Semaine 64 – Hard	XML	✅
Week 63 – Hard	Query Profiling	✅
Week 62 – Intermediate	Native Apps	❌
Week 61 – Intermediate	JSON	✅
Week 60 – Intermediate	Phonetics	✅
Week 59 – Intermediate	Snowpark ML	✅
Week 58 – Basic	REPLACE	✅
Week 57 – Basic	ILIKE	✅
Week 56 – Intermediate	UDF & Alerts	✅
Week 55 – Basic	GROUP BY ALL	✅
Week 54 – Intermediate	Stored Procedure	✅
Week 53 – Intermediate	Infer Schema	✅
Week 52 – Intermediate	Dynamic Tables	❌
Week 51 – Advanced	Native Apps	❌
Week 50 – Beginner	Snowpark	❌
Week 49 – Intermediate	XML Parsing	✅
Week 48 – Intermediate	Alerts and Messaging	❌
Week 47 – Basic	Tagging in Snowsight	❌
Week 46 – Advanced	Recursive CTE and Array	✅
Week 45 – Advanced	Snowpark UDFs	✅
Week 44 – Basic	Security	❌
Week 43 – Intermediate	JSON & Python Worksheets	❌
Week 42 – Intermediate	Tasks	❌
Week 41 – Basic	Python Worksheets	❌
Week 40 – Basic	Memoizable Functions	❌
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!