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.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
Is it possible to do real time monitoring of the current state of an Alteryx Gallery? I want to be able to inspect the current queue of the server, what jobs are queued, who owns them, when they were queued, etc. such that the admin can better understand what and who causes these queues, possibly in a visualization in Tableau.
I know that Alteryx has built a macro that extracts such data from the Gallery and outputs it in Tableau, but it needs to be relatively real-time to satisfy the purpose of immediate action to manage the current queue. Here
It is to be used on a busy server that is often suffering from long queues and thus it is best if the solution is not related to running an Alteryx Workflow (as this could end up in the queue as well worsening the issue.)
I have investigated the Gallery API for the local host URL, but it doesn’t seem to include the relevant data in question.
Also, I have read in the Community that log files are locked when the given job is running, so this is also not an option as far as I understand.
I am very curious to hear any input to this. Did anyone succeed in doing something similar?
This is much needed and would be very valuable. The only thing that comes close, out of the box is looking at the Queue via Designer, Options, View Schedules, Queue. I've heard of people scraping the queue with the Mongo Input tool and doing funky things with that, but it's very complex. While I've built plenty of Mongo modules using the Mongo Input tool, nothing comes close to what you describe.
I looked into your suggestion of looking at the queue via Designer and it seemed promising, but not quite the thing since it is too much of a requirement to open Designer and look at the jobs there. More information is needed and in a more neat display.
However, from further experimenting with the API it actually seems to be possible with the GET /admin/v1/workflows/jobs/ endpoint.
Then it should be possible to enrich it by joining that with user information from another endpoint and finally getting the computational utilisation from the command line with something like
wmic /node:machinename cpu get loadpercentage
All this can be done in Python and run relatively often to approximate real-time insights.