[{"_1":2,"_42":-5,"_43":-5},"loaderData",{"_3":4,"_10":11,"_40":-5,"_41":-5},"root",{"_5":-5,"_6":-5,"_7":-5,"_8":9},"user","shoppingCartId","toast","locale","en","routes/_store+/_readers+/email_author.$slug/route",{"_12":13,"_39":-5},"book",{"_14":15,"_16":17,"_18":19,"_20":21,"_22":23,"_24":25},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvNjEyNTI","title","Top 10 Ultimate Snowflake Challenges","state","published","contactAuthorMethod","email","aboutText","

Top 10 Ultimate Snowflake Challenges is an exciting collection of hidden hands-on gems for Snowflake, presented in an original manner. The live interactive version of this book has been implemented as an Udemy video course as well.

I’ll challenge you here with questions in 10 different Snowflake areas that I found being exciting over the years. I will provide hands-on solutions in either SQL or Python.

Each challenge will start with a Question, after which I may give you some additional explanation and hints. When ready, read my own Answer, starting with the next page. Write me back if you find a better solution (I'm always glad for feedback). A final Conclusion chapter will close the challenge.

In a challenging but funny and engaging way, you’ll learn about time travel in Snowflake, pivot queries, Streamlit apps, Python worksheets, data clean rooms, access policies, and so on...

","authors",[26],{"_14":27,"_28":29,"_5":30},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci82NDgwMg","name","Cristian Scutaru",{"_31":32},"avatar",{"_33":34,"_35":36,"_37":38},"url","https://d308did4coypzi.cloudfront.net/avatars/3370950/medium/profile-33.png?1727972489","styleName","medium","exists",true,"currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the author