We have a few thousand Alteryx designed workflows built by various users and teams over the years. Currently we are in the process of migrating from SQL server data warehouse to Snowflake cloud data warehouse and to make life easier for the end users would like to automate the process of replacing the connection strings from SQL server to Snowflake and also update the embedded SQL code from Snow SQL.
Alterxy Designer UI shows connection under Workflow dependencies which can be edited. Can this be edited/updated via a Python script?
I see Alteryx provides API's and SDK's, however I have not found a clear answer. Would appreciate some examples.
I am pretty new to Alteryx and would like to ask for some guidance and recommendations to accomplish this.
Thanks!