SQL Views in Elastic

Is there functionality in Elasticsearch that would be comparable to that of a view in SQL?

What I would like to do is use a query (a complex aggregation) as the "definition" of a new index.

Lets say I have index-A that has daily sales data in it. I would like to enrich index-C with yearly sales data. Is it possible to create an aggregation query and then store that query as index-B. Essentially, so every time I query index-B, it goes and aggregates index-A for me.

This would enable me to use index-B as the source index for an enrich policy that adds yearly sales data to index-C.

The definetly Tranforms is your solution

1 Like

Bless you Yassine! Thanks so much :slight_smile:

1 Like

thank you for sharing with us

2 Likes

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