You can pursue nearly any kind of analysis at scale with the low-code ease of Alteryx and the high performance of Snowflake. Define custom analytic building blocks in Alteryx that push processing directly to the Snowflake Data Cloud. Alteryx can leverage Snowflake’s user-defined functions capability (currently in customer preview) enabling sophisticated data preparation, blending, and modeling analytics within the data cloud.
If you’re like most Alteryx users, you’ve got valuable data living in databases and data warehouses in your organization that you want to analyze. At Alteryx, we take accelerating your time to value with big data seriously. For example, Alteryx recently announced a partnership with cloud data platform Snowflake, meaning you can leverage Alteryx In-DB tools with your valuable Snowflake data.
If you frequently work with large datasets, you’re probably already a fan of our well-loved In-DB tools. In fact, Alteryx In-DB capabilities are so helpful in reducing processing time and enabling analysis across huge datasets, that I can no longer count the number of times I’ve been asked, “How can I do this In-DB?” Well, if you’re a Snowflake user, I’m excited to share that Snowflake has just launched public-preview capabilities that will help you basically do whatever you want in DB!
Details, you say?? Snowflake has introduced Java in their user defined functions, also known as UDFs. With Java UDFs, customers can bring functions they have in JVM (Java Virtual Machine) and execute right inside of Snowflake’s data cloud with Snowflake’s powerful processing engine. How does this lead to your total In-DB nirvana? Let me explain with a demonstration.
Here’s how you can use this functionality to perform sentiment analysis on a dataset in Snowflake using the in-database, Java UDF extensibility.
Let’s imagine you own a music supply company and you have a continuous stream of data regarding customer reviews of the products you sell at a music store coming into a Snowflake table. You, of course, want satisfied customers and you want to quickly address any issues they may have had with the products you sell. Whenever there is a negative comment about one of your products, you want your customer service team to reach out to the customer to help rectify the issue.
So, let’s dive into Alteryx to show you how this is done and then we will show you how to set this up on your own.
Now that you’ve seen the power of moving some of the processing upstream, let us take you through how to do this in your own environment.
Now that you’ve seen how it works, I encourage you to go it on your own! Here’s what to do next:
Hope you enjoy!
Oh, and if reading this post piqued your interest in making better use of Alteryx with your Snowflake data, but you’re not ready to go the custom-functions route, a fun and easy way to get started is with the Alteryx Starter Kit for Snowflake.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.