Create Snowflake View

[AlterKL]

Hi Community,

is it possible to create a snowflake view with Alteryx?

I believe creating a table is the default output, but I saw some SQL options in the output tool as well and was wondering if they can trigger a 'create view' or if there are other options.

Thanks!

[simonaubert_bd]

Hello @AlterKL 

Short answer : you can't create view with Alteryx. There is an idea you can vote here : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-DB-Create-View/idi-p/157886

Longest answer : you can use a dynamic in db output to get the create table query, modify it with a formula and execute it with a pre/post sql in input data tool.

This is the same process than for statistics detailed here : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Calculate-statistics-after-write-in-DB/idi-p...

Best regards,

Simon

[apathetichell]

@simonaubert_bd you can in pre/post sql in ouptut tool - no?

This could all be solved with a generic SQL tool - which allowed for native DDL/DML  IN-DB.

[simonaubert_bd]

@apathetichellWell, you can type the create view SQL query in pre/post SQL. However, my suggestion to @AlterKL  is more to retrieve the query automatically, dynamically with the little help of the dynamic in db output. It's a nice turnaround of the impossibility to create view directly. But you're right on one thing ; I guessed the user doesn't have already the create code.. If he already has it, yes, no need to retrieve it dynamically.

Best regards,

Simon

[apathetichell]

@AlterKL could you explain what kind of VIEW your are looking to create like holistically how does it fit into your workflow?

@simonaubert_bd - do you agree on the SQL tool  for DDL/DML? After they change the Download tool to the API tool - this will become my new raison d'etre.

[simonaubert_bd]

@apathetichellSQL all the way, you said it ! That's why I'm one of the biggest contributors to in-database or sql related ideas ;)