Elasticsearch Query from Redash


#1

Hi,

I’m trying to extract some data from an Elasticsearch instance through Elasticsearch/ Kibana data sources.
The structure of my data in elasticsearch is like the following:
{
passicarrabili”: {
“mappings”: {
“doc”: {
“properties”: {
cittadino”:{
“properties”:{
nome”:{
“type”:“text”,
“fields”:{
“keyword”:{
“type”:“keyword”,
“ignore_above”:256
}
}
},
cognome”:{
“type”:“text”,
“fields”:{
“keyword”:{
“type”:“keyword”,
“ignore_above”:256
}
}
},
(…) and so on.

The question is: does redash support nested fields? when I try to get results (without any filter) it returns something like this:
–> One Column representing only the first level key
–> Json-like output inside the column.

image

Is there anything that i’m missing? What can i do to get all columns separately?

Thank you very much

Giovanni