Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Table doesn't exist or authorised in Snowflake

DaisyJones
8 - Asteroid

Hi all, I have a workflow which has three outputs and I need them to create a table in Snowflake. I've been using the Snowflake Bulk Loader as my file format because I read that is what I needed to do to write into Snowflake

 

2/3 of the outputs have worked as I wanted but the final table keeps on coming up with this error:

 

Error SQLPrepare: SQL compilation error: Object '"table"' does not exist or not authorized.

How do I resolve this issue?

1 REPLY 1
apathetichell
19 - Altair

Question! Does the table exist? Are you authorized? Are you writing via datastream in? A good way to check if your table exists and if you are authorized is checking in Snowsight. If Snowsight and Alteryx differ perhaps you are logged in as a different user (ie a service account) in one location- or perhaps your authentication has timed out.

Labels