Step 2 - How to prepare your data in Elasticsearch Kibana?

You are now connected to Octave.io, you have uploaded your file in your private and secrured environment, you have previewed your data and determined your file delimiter. You have opened Octave.io's "drop to Kibana" tool, entered an indice name and specified the delimiter. You are now on the Kibana Playground.

If you have not done all this, please check our previous article about the "Drop to Kibana" step by step tutorial.

(You can check our step by step tutorial on youtube)

Preparing your data for Kibana

The first thing you need is to get your file in Kibana. In order to do that, you must go to the management menu.

Then open index management link from Elasticsearch menu  to literally call your file in Kibana with your file indice name. 

Elasticsearch has your file in its database. You should easily find it.

Now you have to create an index pattern for the Kibana library to let you play with data. You need to help Kibana to make a bridge to Elasticsearch database to process it. To ease this step, we advise to copy your file indice name from Elasticsearch  Index management  (the name is quite long, so better to do it that way to avoid mistake 😉) , then click on "Index pattern" in the Kibana section.

Then, click on "Create index pattern"...

Kibana is now searching in Elasticsearch database. The index pattern is like a relay between Octave.io, Elasticsearch "database" and Kibana.

Step 1 of 2 : Paste your index name

You have to call your file index name... now you can paste your file indice name in the index pattern box (and you better understand our previous advise on copy 😉)

Step 2 : The time filter

You can configure the file time filter. In our example, the time table is the field called "df_duedate".

You have no obligation to use a time filter, but you'll see in our next tutorial how interesting it is.

Click on "Create index pattern" and now... your data are available in Kibana! You can already see the fields that are well processed in Kibana. In our file, we have a geolocation fields. You'll see in the next tutorial why we are so enthusiastic about it.

Well done! You can now play in Kibana playground and have access to the data visualization of your entire file!

You can check out the full steps in the video or skip it to move on next step if you're ready to discover your data in Kibana!