Pushing Distinct values from an index to another index

Is there a way to push distinct values of a field from indexA to a new indexB on a regular basis(daily or monthly)?

Use Case: I want to create indexB from one of the fields of indexA, and on a daily basis do an update on this index to be used for filtering.

Welcome!

That sounds like a good candidate for the reindex API.

Thanks @dadoonet for your reply.
I am checking out reindex API now.
Can we do that on a regular basis directly from Kibana using a Watcher or any other service?
like running this query each day?

IMHO that would probably be easier to run that from a cronjob.

But you can probably use a watch with a webhook: Watcher webhook action | Elasticsearch Guide [7.12] | Elastic

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.