SQL Tips (4)

Tricks and tips when working with SQL

How to unnest / extract nested JSON data in MySQL 8.0 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.

Dave Ganesan · July 24, 2020 · Using Holistics How to unnest / extract nested JSON data in BigQuery SQL Tips

How to unnest / extract nested JSON data in BigQuery

Ha Pham · July 02, 2020 · SQL Tips How We Built Our MRR Dashboard (Using Pipedrive & Holistics) 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!

Trang · September 07, 2018 · Lean Analytics Splitting array/string into rows in Amazon Redshift or MySQL SQL Tips

Splitting array/string into rows in Amazon Redshift or MySQL

Huy Nguyen · September 28, 2016 · SQL Tips