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!