ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Snowflake Temp table issue - "Object '""' already exists"

akasubi
8 - Asteroid

We have an issue in our workflows in the Server when connected to Snowflake using the "Write in-db" tool and select output type as "Create temporary table".

 

The error message we get is the following "Error: Write Data In-DB (3): Error running PreSQL on "NoTable": SQL compilation error:
Object '""' already exists."

 

Has anyone come across this issue before? This output mode should create a unique table name so is a bit odd to be receiving this error message.

 

 

I should also mention that we had just migrated the server to 2023.1 and the workflow ran without any errors prior to this upgrade.

0 REPLIES 0