Problem using Redash to visualize Elastic Search Data(ES)

I am having a problem using Redash to visualize ES data.

Here is the format of response returned by ES:

{
"took": 225,
"timed_out": false,
"_shards": {
    ...
},
"hits": {
    "total": {
        ...
    },
    "max_score": null,
    "hits": [
        {
            ...
            "_source": {
                "data": {
                    "mobile": 1,
                    "label": "Test",
                    "completed": 1234561,
                    "id": "2002",
                    "url": "http://www.example.com/",
                    "average": {
                        "firstView": {
                            "loadTime": 1234
                        }
                    },
                    ...
                }
            },
            ...
        },
      ...
    ]
}

}

t seems that Redash can only view the “data” JSON object as a whole, rather than extract detail children information of “data” object, which make Redash cannot successfully visualize the response (say, based on completed and loadTime).

Thus, is there a way to visualize this type of data format? Thanks.

This is a limitation of the ES query runner. It was a community contribution several years ago and it badly needs to be replaced.

We’re already at work on a better query runner. But for now, your query won’t work.