Setting up new connection to Snowflake in a workflow when new user wants to use it

Question

Hello everyone,

I'm using Alteryx Designer (Version: 2023.2.1.7).

Recently I made a workflow in which data coming from tables in Snowflake using Input Data tool. To do that, I made a connection to Snowflake like what is explained in this link: 
https://knowledge.alteryx.com/index/s/article/How-to-Connect-to-Snowflake-from-Alteryx

If I want to share my workflow with a colleague, he can not use that workflow with a connection setting I made. The error is shown below

He has to set up his connection to be able to connect to Snowflake. However, when he does that, the query written inside the Input Data tool will be disappeared.
Is there any solution to not loosing the query? I'd just expected to set a new connection, and not doing every thing from scratch and inserting the query.

Thanks in advance for any help you can provide.

apathetichell · Answer

your coworker needs a snowflake connection with the same naming convention in odbc 64. they need a snowflake driver. I keep these things in a handy .zip with a .bat script to download the file and run regedit to import the same registry rentries I use for my snowflake set up.

I am 100% sure that on prior version of Alteryx queries in IN-DB tools did not change if the user did not have a connection set up with the same naming convetion. Can you confirm that the user loses the query if th connection is set up - if the same happens on IN-DB - I'd flag that as a bug.

jrgo · Answer

You'd likely be better off configuring a non-DCM connection if you intended to share the workflow file with other Designer users.

If you're required to use DCM, one option you can do is copy the SQL statement into a Comment box so that it can be copy/pasted it back into the input tool when the DCM is reconfigured.

Also remember that an Alteryx workflow file is simply XML code so you can open the .yxmd file in a text editor and extract the SQL from there as well. You may even be able to update the DCM connection parameters from there also, but always a good idea to have a backup of the workflow before saving any manual edits made to the XML code.

cjaneczko · Answer

This answer isn't going to help you with preserving the workflow with the new connection string but may help in rewriting the query. On his machine you can recreate the query by copying the existing one before setting up the connection. So they can just copy and paste it into the workflow once the connection is created. With the workflow open, if they go up to Options > Advanced Options > Workflow Dependencies, then click on the Show Individual Tools link you can copy the query from the workflow. Paste this into a word doc for temporary use, then setup the connection string. Copy the SQL from the Word doc and paste it into the Query area of the input tool.