We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
20 - Arcturus

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
Top Solution Authors