amazon-redshift Reading JSON array in Redshift

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Introduction

Currently, reading all elements in JSON array is not possible in Redshift. For e.g. if you want to read Manufacturer and model as columns from following JSON

Remarks

dim_idnumberinfomanufacturermodel 2001Nissan~Sentra^Nissan~Maxima^Ford~Taurus^Ford~Escort^NissanSentra 2002Nissan~Sentra^Nissan~Maxima^Ford~Taurus^Ford~Escort^NissanMaxima 2003Nissan~Sentra^Nissan~Maxima^Ford~Taurus^Ford~Escort^FordTaurus 2004Nissan~Sentra^Nissan~Maxima^Ford~Taurus^Ford~Escort^FordEscort


Got any amazon-redshift Question?