SQL Puzzle Optimization: The UDTF Approach For A Decay Function

Описание: How do you implement a decay function in SQL? You can use window functions, which scale better than joins, or better yet, you can try what Felipe Hoffa did: use tabular UDFs. In this video, Felipe shows you how you can use a tabular UDF to write custom code that can analyze a table row by row while preserving state. Felipe wrote a table UDF in JavaScript that uses a low amount of memory to keep track of the decaying values. He was able to run it in 36 seconds, instead of the 46 seconds that the SQL with windows solution took; and then he optimized the JavaScript even further and ran it in just 9 seconds. Read more detail on how Felipe did this in his blog: https://bit.ly/38kJ442

❄Join our YouTube community❄ https://bit.ly/3lzfeeB

Connect with Felipe Hoffa:
Twitter: @felipehoffa
LinkedIn:   / hoffa  

Learn more about Snowflake:
➡️ Website: https://www.snowflake.com
➡️ Careers: http://careers.snowflake.com
➡️ Podcast page: https://bit.ly/3sFXst6
➡️ Twitter:   / snowflakedb  
➡️ Instagram:   / _snowflake_inc  
➡️ Facebook:   / snowflakedb  
➡️ LinkedIn: https://bit.ly/2QUexl4
➡️ Sign up for our weekly live demo program and have your questions answered by a Snowflake expert at https://bit.ly/2TdVCmJ

Listen on:
🔈 Apple Podcasts: https://apple.co/3cCdrCU
🔈 Spotify: https://spoti.fi/39vCNjH
🔈 Simplecast: https://bit.ly/3rFCrgA




#Snowflake #DataCloud