Using Python In Alteryx

Question

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

abacon · Answer

@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

berno11 · Answer

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?

berno11 · Answer

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