How do I extract the values of a key in JSON ?

[4a87b4a36dad41706305]

I have a JSON file, which contains something like

{

  "createdAt": "2017-12-15T08:47:11.484Z",

  "updatedAt": "2017-12-15T08:47:11.484Z",

  "updatedBy": "administrator"

}

How do I get the keys in to a column, for example create columns "createdAt", "updatedAt" and "updatedBy" and populate it with the content of each key ?

[44619e163d12cf5f0d39 · Accepted solution]

You can use a two step process

1) flatten the data and set the type to "map"

2) use unnest to create columns based on specific key-value pairs

A great example can be found in the KB, type in the search bar "un-nesting JSON" and select the article that shows up

[4a87b4a36dad41706305]

Thanks, the referenced KB is great and does the trick.

In my case I had to use simple the unnesting , was very easy and straight forward.

Thanks!