This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am looking for a way to collect the SQL statements executed from the Gallery to any/all database sources. We have a data source where the schema can change frequently and I need to gather up all the queries run against this database to see if any of the affected tables are being used. The premise is that once I get the queries, I can easily run a Find on the output and ID the workflow. (This may not be perfect but is better than waiting for the workflow to fail AFTER the source was updated...)
I know we can connect to a yxmd file and view as a xml source BUT that seems to only work for locally stored files. Anything that is uploaded to the Gallery is somehow transformed. I've connected to the Gallery MongoDB but the data is either encrypted or not on a Collection we have access to. (cannot locate the uploaded ymdb files)
Has anyone developed a method for accessing this information?
Assuming you are able to RDP into your Alteryx Server to access the Alteryx Server System Settings... another option you can explore is to have your Server save out the run messages to a specific directory.
It's disabled by default, but if a directory is specified in the field highlighted below, it'll write out a .log file that contains all the run messages a job produced. From there, you could create a Workflow that would run through these files and parse out messages that look like SQL text (RegEx will probably be needed).
The naming convention of the log files are "Alteryx_Log_EPOCHTIMESTAMP_1.log". The last digit would increment if there were multiple jobs that executed at the exact same time. The name of the workflow would be listed in the log text.
The Tableau dashboards are quite impressive unto themselves. (They look a lot like what we use for our Tableau Server monitoring.) I cracked into the macros and isolated the sections for the data I am interested in. The key is using the AlteryxService_Client.dll to parse up the blob data. (Seems to decrypt the data) The resulting Excel output gives me a list of workflows that executed on the Gallery which contains the database query used.
From there, I can run my lookup software to find the tables/data fields we are looking for.