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