We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Creating Snowflake Views Using Alteryx

6 - Meteoroid

Is there a way to create Snowflake Views with the Alteryx Snowflake Connector?  Can Views rather than  Tables be created using the Alteryx environment? Has anyone had any success doing this?  I would assume an approach would involve writing a custom script? Can anyone with any experience with this please advise.


Information on Views from Snowflake:



8 - Asteroid

do you want Alteryx to generate syntax to create a view in your database or do you want a view-type widget in Alteryx that you don't have to code each time or do you want to use a database view in Alteryx?

12 - Quasar

Hello @derreck0218 


You cannot create a view natively on Alteryx. There is this idea you can vote for : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-DB-Create-View/idi-p/157886


However, I have a macro that is capable of creating a view. Here a screenshot :

The dummy table is just a table with one colun and nothing more.

Best regards,



18 - Pollux

This ties into a bigger issue - more granular level control of DDL. It would be great if we could this directly In-DB - perhaps something like a code/SQL editor in Datastream-In/Write In-DB.


6 - Meteoroid

Either to generate the syntax to create a View in the database schema or to your latter point using the In-DB tool to create the View rather than Table.  In terms of using a View, I have been able to see those and use those to query.  Part of the issue is that I also want to create a View on top of View.