amazon-redshift Tutorial => Reading JSON array in Redshift

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

Reading array elements in JSON

PDF - Download amazon-redshift for free

Previous Next

amazon-redshift

Fastest Entity Framework Extensions

Introduction

Remarks

Got any amazon-redshift Question?

amazon-redshift

amazon-redshift Reading JSON array in Redshift

Fastest Entity Framework Extensions

Introduction

Remarks

Reading JSON array in Redshift Related Examples

Got any amazon-redshift Question?