Perhaps using unnest?
select unnest(value, recursive := true) from read_json('~/Data/example.json')
Kit Menke
@kitmenke.com
372 followers 395 following 59 posts
Data Engineering leader in Saint Louis, STL Big Data I.D.E.A. meetup organizer, lifelong learner and teacher. He / him #dataBS
