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 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.