Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Snowflake Bulk Upload "User Not Found" when opening workflows from Gallery.

balders-ie
7 - Meteor

Hi there, 

 

We are using Alteryx to bulk upload data to Snowflake, and we can create workflows with the bulk upload output and publish them to Server and they run fine when scheduled on Server. 

 

However when we then open the workflow again on our machines from Gallery, then part of the connection string is lost and user is not found. This is what it looks like when opening the workflows. 

 

User Not Found Error.png

 

Designer and Server Version: 2021.3.4

Snowflake Driver: SnowflakeDSIIDriver 2.23.02.00 

 

The DSN is set up with the following fields filled in:

Data Source, User, Server, Warehouse, Role & Tracing

 

while the rest are left blank. It doesn't feel like a driver issue because the workflow runs successfully on Gallery when uploaded there,  but when opening the workflow in Designer from Gallery that information breaks. 

 

Any help with this would be much appreciated. 

 

1 REPLY 1
balders-ie
7 - Meteor

As an addition to this, if I download the yxzp from the browser and open it in designer, that opens with details maintained but it is sub-optimal because then republishing requires publishing new versions to Gallery every time and going through the Replace Workflow functionality.

Labels