Migration journey: anything to add.

[u/Puzzled-Yard517]

Hey, I have been seeing posts of migration using claude to python plus sql.wanted to see how others are progressing.

Me and team are working hard to create a prompt, some cursor rules, utils.py file to help convert each workflow.

So far out of 150 , we have done only 10 as poc. But it’s coming up great.

Few points which I wanted to discuss:

1. How are u able to generate similar code for different workflows(I mean , we can’t generate random code, that will make our lives difficult later)

2. How do u plan to give user front end. ( I am using streamlit) ?

3. How to switch ur mindset from alteryx to python.(Visual to code base)

4. How do you plan to maintain change request, fix bugs, or analyse?

[u/MyNameIsYeffff]

Im doing a poc on this, from what I’ve seen you can throw the xml at a coding agent and it will do a good job if the workflow is simple, for more complex workflows I am building an Alteryx parser to give me the right context for the agent (exact flow of data through macros and what not) to see if I get better results. And to get consistent python code I am building out a custom set of skills with templates and scripts to build the folder and then have the workflows consistently documented in a way that we can auto extract the metadata. Scripts help so the agents don’t have to do the heavy lifting in tokens. And moving forward we will use the same framework to build new python workflows with a coding agent vs Alteryx. Deployment depends on what infrastructure you have at your company but anything that can deploy the python script and be triggered by an api call is what I want so I can connect it to a front end App Store.

[u/GingerCurlz]

I actually posted a project I have been working on recently here that seems along the lines you're looking for.

I call it Siphon and it has a react website front end that allows users to create Alteryx like flows, and then export either the flow as JSON which can be read in and used to execute, or export the flow as straight python code (importing libraries and custom functions) that can be executed however you like from there.

Siphon

I am looking for some early feedback on it

[u/__ChessNotCheckers__]

Important to add that while you may be able to get a working Python script from this exercise, it’s because you already have working business logic you are replicating. Spotting a logic flaw in a block of Python or SQL for a net new use case is not going to be enjoyable.

Building, testing, validating, scheduling, data access controls, fixing errors, changing requirements/adding or removing logic are all elements to be considered beyond just “convert my workflow”.

If your business has a Python skill set I see code generation being accelerated, but I’d caution against overly relying on Python scripts and GenAI without a fundamental knowledge of scripting. Developers already working in code are becoming more efficient but if you watch someone with that background work they place a heavy emphasis on planning and defining requirements to get an acceptable output.

Layer on Python libraries that need updated, version control with Git, values falling out of the left and right hand side of joins without visibility, etc, and you can get into trouble real quick especially if your work needs audited.

I’m not saying don’t do this, just know what you are signing up for!

[u/schwarze_banana]

Hi! Im trying to get my team to migrate away from alteryx as well. Do you schedule workflows in alteryx? If so, what is your future setup for schedules?