# Dremio cannot interpret JSON layer in detail from ElasticSearch data source **URL:** \ **Category:** Uncategorized\ **Created:** [January 15, 2019, 3:19am UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555 "2019-01-15T03:19:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Carillpower](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@Carillpower](https://community.dremio.com/u/Carillpower)\ **Post date:** [January 15, 2019, 3:19am UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/1 "2019-01-15T03:19:31Z")
Hi Guru’s, Im running my own research on utilization of dremio into our production data analytics. During my research, I found an issue that not sure how to solve it. I’ve manage to connect dremio with my data source from ElasticSearch Cluster, but notice that dremio only manage to translate only 1st layer of JSON tree to columns, not for 2nd and 3rd layer onwards. See below as example ![](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/ac788bb7d4180c4e7d1adbbb0146082848c0555d.png) So far now I’m keen to use dremio as middle man between ElasticSearch as main data lake and client BI tools. Therefore I would highly appreciate if your end have any suggestion or recommendation on above issue if it’s possible to be fix. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [January 15, 2019, 3:33am UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/2 "2019-01-15T03:33:30Z")
Hi @Carillpower If you hover your mouse to the right of a field value, there should be 3 dots, you should be able to click on that, extract out another nested field and again unnest, like screenshot below ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/62dad4d3c41738d1a5c1199d6c30c74abf7fb973.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/e/efa27b769b619f4de94c64722023078f185d4d3a.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/1/14d9a4ce12a6b28653e8433efc55115f15f85a56.png) Thanks @balaji.ramaswamy ---
**Author:** ![Carillpower](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@Carillpower](https://community.dremio.com/u/Carillpower)\ **Post date:** [January 15, 2019, 5:00am UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/3 "2019-01-15T05:00:32Z")
Hi Balaji, Thanks for your quick response, yes I’ve test it and it works like a charm! Just a quick check, does this feature could be made as defaut or at least extract all in bulk instead of every documentSet ? ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [January 15, 2019, 7:21am UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/4 "2019-01-15T07:21:27Z")
Good point @Carillpower. Let me check on that internally and get back to you Thanks @balaji.ramaswamy ---
**Author:** ![Carillpower](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@Carillpower](https://community.dremio.com/u/Carillpower)\ **Post date:** [January 15, 2019, 1:21pm UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/5 "2019-01-15T13:21:54Z")
Cool, thanks Balaji … will wait for their response 👍 ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [January 15, 2019, 4:21pm UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/6 "2019-01-15T16:21:52Z")
Hi @Carillpower Currently we unnest only one level, further un-nesting needs to be done via the UI or SQL as mentioned above Thanks @balaji.ramaswamy ---
**Author:** ![Carillpower](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@Carillpower](https://community.dremio.com/u/Carillpower)\ **Post date:** [January 16, 2019, 6:22am UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/7 "2019-01-16T06:22:36Z")
Ok then, will try to absorb this limitation for current time being. Hope there’s a roadmap for this in future releases. Thanks for the clarification, really appreciate the effort. ---
**Author:** ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)\ **Post date:** [January 16, 2019, 4:35pm UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/8 "2019-01-16T16:35:08Z")
There are lots of examples of different things you can do in this tutorial on data curation: > **[Data Curation With Dremio](https://www.dremio.com/tutorials/data-curation-with-dremio/)** > > Tutorial that helps new users learn how to curate data with Dremio. Kelly ---
**Author:** ![Carillpower](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@Carillpower](https://community.dremio.com/u/Carillpower)\ **Post date:** [January 16, 2019, 11:42pm UTC](https://community.dremio.com/t/dremio-cannot-interpret-json-layer-in-detail-from-elasticsearch-data-source/2555/9 "2019-01-16T23:42:53Z")
Hi Kelly, Cool, trying it. Thumbs up!