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 trying to query the MongoDB backend of Alteryx using Studio 3T to connect. The collection I am interested in is the AS_Queue, how can I grab the jobs completed in the last hour?
A bit of back story, I want to run a batch query from AWS to a database/lambda to check the DB for number of nodes running and length of jobs in queue to send out alerts if a node goes down (we have 3) or a job extends past a certain run time as an early alerting process.
Hi @GoldenDesign04 - check out this article for How to Efficiently Query MongoDB . Section f. "Query based on a relative date (objects created in the last X days, as an example)" should help you achieve what you're looking to accomplish.