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

SQL Tips

Tricks and tips when working with SQL

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
SQL Tips

How to unnest / extract nested JSON data in BigQuery

Working with nested JSON data in BigQuery analytics database might be confusing for people new to BigQuery. Yet if done well, nested …

Ha Pham July 02, 2020
Lean Analytics Using Holistics SQL Tips

How We Built Our MRR Dashboard (Using Pipedrive & Holistics)

Want to customize and automate MRR reporting, to suit your company's specific data needs? Luckily, Holistics integrates with Pipedrive, here's our guide!

Trang September 07, 2018
SQL Tips

Splitting array/string into rows in Amazon Redshift or MySQL

We've worked with a lot of customers who writes SQL on a regular basis. And from time to time they …

Huy Nguyen September 28, 2016

What's happening in the BI world?

Join 30k+ people to get insights from BI practitioners around the globe. In your inbox. Every week. Learn more

No spam, ever. We respect your email privacy. Unsubscribe anytime.

The Holistics Blog © 2025
Latest Posts Facebook Twitter