Create Snowflake View

Question

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 · Answer

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

apathetichell · Answer

@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 · Answer

@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