Hi, I have created a number of ad-hoc GQI queries. In the next step of my project, I would like to run these queries at fixed intervals - e.g. once per hour, and keep track of how the results evolve over time.
Is there any existing solution for this? Perhaps a connector that can run the queries and trend the results?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 6th September 2024
A more low-level solution I tend to use is to schedule a script run that writes your data to a csv (or whatever storage you want for your table). Then you can use a generic csv ad-hoc data source to extract the data for your LCA or DB.
Of course converting this to a connector or using an aggregator is probably the cleaner solution.
Toon Casteele [SLC] [DevOps Enabler] Answered question 4th September 2024