Using Python In Alteryx

[berno11]

Hi, I have a project that I am working on whereby I need to parse a sql query into alteryx using text input tool. Once this is done, I need to extract the main SELECT output elements from this query followed by their source elements. This workflow will be used as a macro for my coworkers that need to have their sql read via alteryx. Can somebody suggest a python code or a code that I can use to automate this process. Thanks in advance

[dreldrel]

For your case, sqlglot is a recommended library because it can handle many SQL dialects and lets you extract column lineage. You can use this in your python tool. If this helps, please like the comments

[berno11]

Thanks dreldrel for your response. I will try it out and report on my outcome.

[berno11]

I do not have admin capabilities at my organization. what is the best way to navigate around this blockage if I want to utilize sqlglot?

[abacon]

@berno11 Is using Python a requirement in this project? If I am understanding your question correctly, you could probably use the alteryx app functionalities to build an interactive application that takes a SQL query from the users and passes into the workflow.

Bacon