# Converting JSON to tabular structure

**URL:** <https://community.dremio.com/t/converting-json-to-tabular-structure/3290>\
**Category:** Uncategorized\
**Created:** [April 30, 2019, 2:10pm UTC](https://community.dremio.com/t/converting-json-to-tabular-structure/3290 "2019-04-30T14:10:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sajjan.jindal](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@sajjan.jindal](https://community.dremio.com/u/sajjan.jindal)\
**Post date:** [April 30, 2019, 2:10pm UTC](https://community.dremio.com/t/converting-json-to-tabular-structure/3290/1 "2019-04-30T14:10:08Z")

</div>

Hi,

I am working on a complex JSON message to be read via dremio and pass on to Tableau for reporting. I am observing that when I read the JSON message in Dremio, the array and hierarchy are still not normalized. In comparison to Tableau which completely normalizes the data into tabular format. Is there a way in Dremio to completely flatten out the JSON data into tabular structure without writing the flatten clause explicitly for each Heirarchy ?

Regards,  
Sajjan

---

<div class="post-metadata">

**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:** [April 30, 2019, 6:00pm UTC](https://community.dremio.com/t/converting-json-to-tabular-structure/3290/2 "2019-04-30T18:00:37Z")

</div>

Yes. There are several examples here: [https://www.dremio.com/tutorials/data-curation-with-dremio/](https://www.dremio.com/tutorials/data-curation-with-dremio/)

---

<div class="post-metadata">

**Author:** ![sajjan.jindal](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@sajjan.jindal](https://community.dremio.com/u/sajjan.jindal)\
**Post date:** [April 30, 2019, 7:16pm UTC](https://community.dremio.com/t/converting-json-to-tabular-structure/3290/3 "2019-04-30T19:16:47Z")

</div>

Hi Kelly, thx for your response. I have already gone through this tutorial. for complex Json with 20s of arrays and 10 levels of nested architecture within each array element would need me to write a sql query. Tableau does that automatically as soon as I load it in Tableau. was trying to understand if we have a similar utility instead of identifying and selecting each element to expand.

---

<div class="post-metadata">

**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:** [April 30, 2019, 7:38pm UTC](https://community.dremio.com/t/converting-json-to-tabular-structure/3290/4 "2019-04-30T19:38:12Z")

</div>

Not at this time, no. Dremio can query the JSON “as is” so we don’t yet have this feature.