Global find and replace on the server

AndyEllis — Fri, 03 Dec 2021 20:36:46 GMT

We use Alteryx Server on AWS and much of our data connects to a cloud based data lake. The Data lake team is creating new schemas that replicate existing schemas, but the new schema will have a new name.

There are hundreds of input tools in hundreds of workflows that use the current schema and we are looking at having to manually update each of them. Not only is this tedious but it also is a rolling process which will mean some inputs are on one schema while others are on the other one.

All of these things are things we can work around, but I wanted to reach out to the community and see if anyone has ideas about how to do a one time automated process which basically does a find and replace of the sql statements in the input tools.

Basically we need to do a find on a statement like this

select "data-lake".current_schema.user_id

and replace it with

select "data-lake".new_schema.user_id

(Obviously it is more complex than this...but i hope you get the idea)

Re: Global find and replace on the server

ArtApa — Mon, 06 Dec 2021 04:37:15 GMT

Hi @AndyEllis - Given that Alteryx workflows are XML scripts, you should be able to achieve a desired outcome. Logically this would be a 3 step process:

Download workflows via API
Run a workflow that reads all workflow files as text and searches and replaces from old schema to new schema
Upload all workflows via API

Here is a link to an article that gives an idea of how to leverage APIs: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Migrating-Workflows/ta-p/335774

If there is any more information I can provide, please let me know.

topic Re: Global find and replace on the server in Alteryx Server Discussions

Global find and replace on the server

Re: Global find and replace on the server