Creating Snowflake Views Using Alteryx

Question

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:

https://docs.snowflake.com/en/user-guide/views-introduction.html

derreck0218 · Answer

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.

apathetichell · Answer

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.

simonaubert_bd · Answer

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,

Simon