Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.
dhouse
Alteryx
Alteryx

If you’re excited to try out an Alteryx Designer hosted trial with your existing Snowflake instance, follow the instructions in this article.

 

Before You Get Started

 

  1. Ensure you have a Snowflake Admin account. This walk-through will leverage Snowflake Partner Connect, so your user MUST be a Snowflake Account Admin
  2. It may be helpful to read through the Snowflake Partner Connect guide located here: https://docs.snowflake.com/en/user-guide/ecosystem-partner-connect.html
  3. If you use a Network Policy on your Snowflake account, you must ensure the IP address “44.225.50.233” is in your allowed IP Address list. (https://docs.snowflake.com/en/user-guide/network-policies.html)
  4. In order to run the workflow described below, the SNOWFLAKE_SAMPLE_DATA database must be available on your instance

 

Let’s Go!

 

  1. Log into Snowflake with your admin account
  2. In the upper right corner, click on the “Partner Connect” iconNeilR_18-1623190032600.png
  3. If you have not already done so, choose “AccountAdmin” before clicking on the tile or you will be prompted to make that selection. Then scroll down until you see the “Alteryx” tile; click the tileNeilR_19-1623190201572.png
  4. You will see a dialog box listing the objects that will be created and the information that will be shared with Alteryx. Click “Connect”NeilR_24-1623190800235.png
  5. You will then see a dialog box saying your account is ready. Click “Activate”NeilR_25-1623190826179.png
  6. At this point, you are redirected to the Alteryx sign up page, where you will set up your password that you will use to access the trial during the trial period. Be sure to remember to retain your password for future use. The password must be at least 8 characters, contain a lowercase and uppercase letter, a number, and a special character. Review and accept the legal agreements by clicking the checkbox underneath the password. Now click “Sign Up”NeilR_22-1623190625474.png
  7. You will see “Connecting” appear in your browser windowNeilR_5-1623189863217.png
  8. Then Alteryx Designer will begin to loadNeilR_6-1623189863245.png
  9. And then you will see a “Ready to Start Solving” dialogNeilR_7-1623189863267.png
  10. Click “Close tour.” Yes, really! This is the best way for you to see Alteryx Designer immediately interact with your Snowflake database using the Snowflake Sample database
  11. As the text in the green box indicates, click the blue “Run” button in the top right. The workflow will connect to your Snowflake instance and retrieve data from the Snowflake sample database.NeilR_20-1623190457665.png
  12. The workflow that is visible uses what we often refer to as “standard” Alteryx Designer tools. The leftmost icon is an Input tool, which queries Snowflake and streams the data back to this machine, so the rest of the steps occur in memory on this machineNeilR_9-1623189863278.png
  13. If you scroll down on the canvas, you will see a similar set of tools in all dark blue. These are Alteryx Designer’s “in-database” tools. These tools take the steps that have been indicated and package them up as a script that is executed on Snowflake. The only time the records are streamed back to this machine is in the rightmost tool, which is called a Browse tool. This tool lets you see the results of the prior stepsNeilR_10-1623189863280.png
  1. You may now begin exploring Alteryx on your own!

 

Connecting to Your Own Data

 

  1. If you wish to stream actual data into the trial, you must grant the “PC_ALTERYX_ROLE” (created when you first clicked the tile) access to that data
  2. Once access is granted you can change the Input tool that is already on canvas or bring another Input tool onto the canvas

 

Using the Alteryx Starter Kit for Snowflake

 

I highly recommend you jumpstart your journey with ready-to-use business solutions pre-built for you, including customer lifetime value and segmentation!

 

  1. Go to Help > Sample Workflows > Snowflake Starter Kit > English > Table of Contents

NeilR_0-1623342113892.png

 

  1. Then click on any of the array of pre-built workflows, or watch an embedded instructional video to get started

NeilR_1-1623342113936.png

 

Leaving Your Designer Hosted Trial

 

  • If you close the browser window (or tab) the trial is in, you should be able to return to your session where you left it, within the trial period
  • If you choose “End Session” in the top right menu, this will reset the trial to its original state.NeilR_11-1623189863284.png
 

Returning to Your Designer Hosted Trial (during the trial period)

 

There are multiple ways to get back to your trial if you have left:

 

  1. In Snowflake, click the Alteryx tile in the Partner Connect section.
  2. From your email, click the link in the welcome email that was sent to you.
  3. Go to https://www.alteryx.com/api/snowflake

 

You will be prompted to log in with the same email and password you signed up with.

 

I hope you’ve found this walk-through helpful! I wish you happy trails. (And trials!)

 

If you find you’ve gotten stuck along the way and would like some help, don’t hesitate to reach out to Alteryx at https://www.alteryx.com/trial-support.

Comments
kherty21
5 - Atom

I have been trying to get information on costs associated with implementing this hosted solution. I have struggled to find somebody to talk to.  Can somebody here please assist?  Thanks!

Buzz
8 - Asteroid

Hey, will the IN-DB SQL statement be optimized for Snowflake. It makes a huge difference for SAP Hana whether I take the generated SQL statement by the IN-DB Tools or an "optimized" one.