Setting up pivot data transform

Elasticsearch’s data transform is a capability that allows you to create and execute data transforms on your Elasticsearch indices. It enables you to reshape and aggregate data from one index and store the results in another index, making it easier to analyze and visualize your data in diverse ways. This feature is particularly useful for summarizing and aggregating large datasets, creating denormalized views of your data, and preparing data for analytics or reporting.

For this recipe, we will continue with the dataset for Rennes traffic that we ingested with Logstash from the previous recipe.

Getting ready

To set up pivot data transform, you need to do the following:

• Complete the previous recipe of this chapter, Creating a Logstash pipeline.
• Ensure that at least one Elasticsearch node of your cluster is set to the transform role. (Note that if you are using Elastic Cloud, this is configured automatically.) To configure transform...