Running an ESQL query periodally and output the result into an index

xeraa
I actually ended up doing something a bit different

  1. I created a regular Transform that calculates today's inventory
  2. I ran a simple Watcher that copies those entries to a new Data stream. See this Q\A for reference. It adds the inventory date as an extra field to each document, hence creating an inventory history index.
  3. I then used ES|QL to query the inventory index.

So at this point, supporting ESQL to create that inventory data stream would be a cool addition, but no desperate measures needed to be taken!

Thanks :slight_smile: