Snowflake Trial

Challenge Index

ChallengeTopicdbt Friendly*
Week 73 – IntermediateInterconnected Data✅
Week 72 – BasicExecute Immediate❌
Week 71 – IntermediateArrays✅
Week 70 – IntermediateCost Optimization✅
Week 69 – IntermediateSnowflake Mystery Functions✅
Week 68 – IntermediateSiS❌
Week 67 – IntermediateUDF & Objects✅
Week 66 – IntermediateSnowpark✅
Week 65 – BasicUDF & Marketplace✅
Semaine 64 – HardXML✅
Week 63 – HardQuery Profiling✅
Week 62 – IntermediateNative Apps❌
Week 61 – IntermediateJSON✅
Week 60 – IntermediatePhonetics✅
Week 59 – IntermediateSnowpark ML✅
Week 58 – BasicREPLACE✅
Week 57 – BasicILIKE✅
Week 56 – IntermediateUDF & Alerts✅
Week 55 – BasicGROUP BY ALL✅
Week 54 – IntermediateStored Procedure✅
Week 53 – IntermediateInfer Schema✅
Week 52 – IntermediateDynamic Tables❌
Week 51 – AdvancedNative Apps❌
Week 50 – BeginnerSnowpark❌
Week 49 – IntermediateXML Parsing✅
Week 48 – IntermediateAlerts and Messaging❌
Week 47 – BasicTagging in Snowsight❌
Week 46 – AdvancedRecursive CTE and Array✅
Week 45 – AdvancedSnowpark UDFs✅
Week 44 – BasicSecurity❌
Week 43 – IntermediateJSON & Python Worksheets❌
Week 42 – IntermediateTasks❌
Week 41 – BasicPython Worksheets❌
Week 40 – BasicMemoizable Functions❌
Week 39 – BasicCLS❌
Week 38 – BasicStreams❌
Week 37 – IntermediateUnstructured Data✅
Week 36 – IntermediateStored Procedure❌
Week 35 – IntermediateExternal Tables❌
Week 34 – IntermediateData Structuring✅
Week 33 – HardMultiple❌
Week 32 – BasicSession Security❌
Week 31 – BasicMIN_BY, MAX_BY✅
Week 30 – IntermediateSnowSQL & Scripting❌
Week 29 – IntermediateSnowpark✅
Week 28 – IntermediateMarketplace & Ranking✅
Week 27 – BasicSELECT EXCLUDE & RENAME✅
Week 26 – IntermediateTasks & Email❌
Week 25 – BasicJSON✅
Week 24 – IntermediateSnowpark & Streamlit❌
Week 23 – BasicSnowSQL❌
Week 22 – BasicRLS✅
Week 21 – BasicPivoting✅
Week 20 – HardStored Procedures✅
Week 19 – BasicDates✅
Week 18 – HardSnowpark❌
Week 17 – IntermediateSpatial✅
Week 16 – IntermediateJSON✅
Week 15 – IntermediateUDFs✅
Week 14 – BasicJSON✅
Week 13 – IntermediateLast not null✅
Week 12 – IntermediateStreamlit❌
Week 11 – BasicTasks✅
Week 10 – HardStored Procedures✅
Week 9 – IntermediateTags, Masking Policies✅
Week 8 – BasicStreamlit❌
Week 7 – IntermediateTags, Account Usage✅
Week 6 – HardGeospatial✅
Week 5 – BasicUDFs✅
Week 4 – HardJSON✅
Week 3 – BasicMetadata Queries✅
Week 2 – IntermediateStreams✅
Week 1 – BasicExternal 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!