Systems | Development | Analytics | API | Testing

April 2022

How To Scale Threat Detection & Response With Snowflake & Securonix

Securonix brings exciting new capabilities to the field of threat detection and response thanks to its integration with Snowflake. Together, the two companies provide a split-architecture solution that solves the problem of data silos and enables organizations to make better, more timely decisions about potential threats to their organization. It’s a next-gen SIEM solution already finding widespread use in such organizations as healthcare institutions, airlines, and telecommunication companies.

Support Multiple Data Modeling Approaches with Snowflake

Since I joined Snowflake, I have been asked multiple times what data warehouse modeling approach Snowflake best supports. Well, the cool thing is that Snowflake supports multiple data modeling approaches equally. Turns out we have a few customers who have existing data warehouses built using a particular approach known as the Data Vault modeling approach, and they have decided to move into Snowflake. So the conversation often goes like this.

Elevate Gives Retailers a Powerful New Tool for Managing Supply Chains

In today’s world, retail customers expect things fast. They want their products on time and they want their orders not to be canceled. And when things go wrong, they want answers. To deliver that experience, retailers need to be able to understand at a granular level how their customers’ orders are moving through their supply chains. In this episode of “Powered by Snowflake,” Daniel Myers chats with Elevate Co-founder and CTO James Sutton about his company’s recently introduced retail operations platform that provides the analytics retailers need to evaluate and manage supply chain performance.

New Snowflake Features Released in March 2022

In March, Snowflake continued to enhance its capabilities around data programmability and data pipeline development, with the Snowpark API and stored procedures for Java now in public preview, schema detection now generally available, and the Snowflake SQL API generally available. In addition, Snowflake’s user interface, Snowsight, is generally available. Not to mention an expanded selection of new partners to choose from in Snowflake Data Marketplace.

Get Your Retail Plan in Shape: A 7-Step Regimen for Year-Round Selling

Once upon a time, the retail calendar centered itself on the Christmas season. Now, the retail surge is year-round. Not just the wave of traditional seasonal holidays from Valentine’s Day to the 4th of July, but also newer sales holidays, such as Cyber Monday, or even holidays created by some gigantic companies themselves, like Amazon’s Prime Day. Now, instead of a steady pace leading up to a frenzied December, retailers are in sprint mode all the time.

Analyzing Unstructured Data With Snowflake Explained In 90 Seconds

What if there was a way to easily manage, process, and analyze any data type in a single platform? Snowflake is here to help. Simplify your architecture with a single platform for all data types and workloads, unlocking new use cases for your data. With Snowpark, your data scientists and engineers can securely build scalable, optimized pipelines, and quickly and efficiently execute machine learning workflows while working in Python, Java, or Scala.

Unstructured Data Now Generally Available in Snowflake, Processing with Snowpark in Public Preview

We’re excited to announce the general availability of the unstructured data management functionality in Snowflake. We launched public preview of this functionality in September 2021, and since then we have seen adoption by customers across industries for a variety of use cases. These use cases include storing and securing call center recordings, securely sharing PDF documents in Snowflake Data Marketplace, storing medical images and extracting data from them, and many more.

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.