The Holistics Blog Holistics Blog
  • Start Here
  • Business Intelligence
  • Data Modeling
  • Using Holistics
  • Our Newsletter
  • Visit Holistics

SQL Tips

Tricks and tips when working with SQL

Subscribe
Using Holistics

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.

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 …

Lean Analytics

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!

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 come to …

The Holistics Blog © 2023
Latest Posts Facebook Twitter