Creating Snowflake Views Using Alteryx

[derreck0218]

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

[soccertil1108]

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?

[simonaubert_bd]

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

[apathetichell]

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.

[derreck0218]

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.