Systems | Development | Analytics | API | Testing

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.

Drive Retail Profitability, Stability with Snowflake's Retail Data Cloud

In 2022, retailers are still dealing with the lasting impacts of the global pandemic, including a decreased workforce, supply chain disruptions, and surging inflation. At the same time, now is the chance for a “long overdue great retail reset” that could promote stability and profitability, according to a recent Deloitte report.

Sales Compensation in a Consumption Pricing World

Today’s organizations want stronger alignment between the cost of SaaS solutions and the value derived from these products. As a result, many software companies are looking at adopting consumption-based pricing models as an alternative to subscription models. With consumption-based models, customers only pay for what they use, and usage is tied directly to the value customers derive. Of course, consumption means software companies don’t experience revenue until customers use the solution.

Building Production-Ready Machine Learning Features on Snowflake with Tecton's Feature Store

We are excited to announce the integration of Tecton’s enterprise feature store and Feast, the popular open source feature store, with Snowflake. The integration, available in preview to all Snowflake customers on AWS, will enable data teams to securely and reliably store, process, and manage the complete lifecycle of machine learning (ML) features for production in Snowflake. Tecton allows data teams to define features as code using Python and SQL.

How Observe Built An Observability Platform On Snowflake.

The Observability Platform from Observe is a tool that helps engineers and DevOps teams quickly analyze the performance of and troubleshoot problems with an organization’s distributed applications. Its power comes from its ability to ingest any kind of telemetry and machine data–trace data, log data, metric data, billing data, and so on–into a single source using Snowflake, and then map the relationships between data sets. These relationships can be displayed graphically as an interactive visualization, making it easy for end users to trace connections between datasets in order to diagnose the cause of error notifications or gain insight into an application's performance.

4 Innovation-Boosting Features of Snowflake's New Healthcare & Life Sciences Data Cloud

A new study from McKinsey warns that profit pools in the healthcare industry are likely to be flat due to the ongoing effects of the COVID-19 pandemic. To combat this stagnancy, the study identifies a number of opportunities for innovation in the industry.

Using Snowflake to Analyze Unstructured Data

Unstructured data stores a tremendous amount of information, but it is not easy to search, analyze, or query, especially on the fly— presenting more challenges to data architectures that are already complex. In this session, you will learn about Snowflake’s new support for unstructured data and how unstructured data can be used to analyze proprietary replay files for the Dota 2 video game. Dota 2 has a substantial esports presence and its developer hosts the world's largest endowed esports tournament.

Import Google Analytics 4 Data into Snowflake and Translate into SQL

Did you know that Google Analytics 4 now exports event data at the individual user level for free? In this episode of SnowFlake Bytes, Felipe Hoffa, Snowflake’s Data Cloud Advocate, shows you how to move this GA4 data into Snowflake and translate the sample queries into Snowflake SQL. His favorite part of the process? Creating a UDF that transforms the original schema nested data into a variant object that is easier to query.