![](https://www.holistics.io/blog/content/images/2020/07/Nested-JSON-in-MySQL.png)
Using Holistics
SQL Tips
How to unnest / extract nested JSON data in MySQL 8.0
In this article, we will demonstrate how to use the JSON_EXTRACT and JSON_TABLE functions in MySQL8.0 to convert JSON table into tabular data for analysis and reports, and also how to utilise it in Holistics for drag-and-drop reports.