Redash elasticsearch aggregation hierarchy

I am running a path_hierarchy tokenizer query:

{
    "index": "file_path_timeseries",
    "aggs": {
        "tree": {
            "path_hierarchy": {
                "script": "doc['date'].value.toOffsetDateTime().format(DateTimeFormatter.ofPattern('yyyy/MM/dd'))",
                "order": {
                  "_key": "asc"
                },
                "size": 100
            }
        }
    }
}

The results from Kibana look like this:

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 13,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  },
  "aggregations" : {
    "tree" : {
      "buckets" : [
        {
          "key" : "2020",
          "doc_count" : 13,
          "path" : [ ],
          "tree" : {
            "buckets" : [
              {
                "key" : "01",
                "doc_count" : 12,
                "path" : [
                  "2020"
                ],
                "tree" : {
                  "buckets" : [
                    {
                      "key" : "10",
                      "doc_count" : 2,
                      "path" : [
                        "2020",
                        "01"
                      ]
                    },
                    {
                      "key" : "11",
                      "doc_count" : 5,
                      "path" : [
                        "2020",
                        "01"
                      ]
                    },
                    {
                      "key" : "12",
                      "doc_count" : 3,
                      "path" : [
                        "2020",
                        "01"
                      ]
                    },
                    {
                      "key" : "13",
                      "doc_count" : 2,
                      "path" : [
                        "2020",
                        "01"
                      ]
                    }
                  ]
                }
              },
              {
                "key" : "02",
                "doc_count" : 1,
                "path" : [
                  "2020"
                ],
                "tree" : {
                  "buckets" : [
                    {
                      "key" : "02",
                      "doc_count" : 1,
                      "path" : [
                        "2020",
                        "02"
                      ]
                    }
                  ]
                }
              }
            ]
          }
        }
      ]
    }
  }
}

The results from redash only return doc_count 13 and tree 2020. Is it possible to show all of the response in redash so I can make visualizations?

Any help appreciated, cheers!

This may be a limitation with our query runner. We’re working on a rewrite which you can follow here. The existing runner was a community contribution and has a lot of issues.