The Holistics Blog
  • Product
  • Pricing
  • Docs
  • Worldview
  • Blog
  • More
  • Login
  • Free Trial
  • Book a Demo
  • Login
  • Free Trial
  • Book a Demo

Dave Ganesan

1 post •
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.

July 24, 2020
The Holistics Blog © 2025
Latest Posts Facebook Twitter