How to Create a Table in Snowflake with Alteryx?

[McBrideW]

How can I create a table in Snowflake using Alteryx?

[BrandonB · Accepted solution]

You can use the Output Data tool to leverage the ODBC connection you set up to Snowflake on your machine. Super quick and easy!

[BrandonB · Accepted solution]

Here is our help article for setting up the data source properly: https://help.alteryx.com/current/designer/snowflake

[McBrideW]

Hi Brandon - I need additional information when using a S3 bucket.  What is the proper pre SQL statement which allows me to choose Role, Warehouse, and Schema?  See print screen below.

[rohit782192]

Hello

@BrandonB 

How can we create a Single Table for SnowFlake . 

In addition when the workflow run multiple times only Date should be deleted and update with a New one and Not Full Table should be created again

[BrandonB]

@rohit782192 rather than clicking snowflake bulk loader in the drop down of the Output Data tool, I suggest navigating to it via the UI

It will then prompt you for the ODCB connection that has been set up and ask you for your AWS access key and secret key for staging. 

You also have the option to use a Local stage (User stage, table stage, or other internal named stage)

[BrandonB]

If you are looking to just do an update, I would suggest using the regular ODBC connection, as bulk connections only allow for Create New Table, append existing, delete data and append, and overwrite table (drop)

[rohit782192]

@BrandonB  I want the Table to create Once and update multiple times . Only Truncate no delete

[BrandonB]

@rohit782192 it sounds like delete data and append is the option you will want to take. This option "Deletes all the original records from the table and then appends the data into the existing table." It does not delete the table itself, only the records within it prior to writing the next set. 

[rohit782192]

@BrandonB 

Can you elaborate more like where is this Option Present.

I am unable to search. It would be of a Great Help.