Creating temporary table in Snowflake using Alteryx Output tool.

[leannedayao]

Hi, 

I'm trying to load data in a Snowflake temporary table. Is this approach correct?
I planning to use a Pre Create SQL statement to create the temporary table and choose Append Existing as output option.

USE DATABASE database_name;
USE SCHEMA schema_name;
CREATE OR REPLACE TEMPORARY TABLE temporary_table
(column_name VARCHAR);

 

[apathetichell]

I don't use output data with DBs all that often - but my memory is that you can do this on datastream in if you have your db (and maybe your schema) set up in the odbc 64 connection.

[apathetichell · Accepted solution]

I wouldn't define temporary table in my presql  - and I wouldn't append to a temporary table. I'd drop/overwrite. you can try doing what you are doing with your create statement ommitted and post here any error messages.

[leannedayao]

I decided to go for the Delete & Append option and no issues so far. Thanks!