Can you store JSON fields on Redshift?

json amazon-redshift
Some Guy picture Some Guy · Sep 22, 2015 · Viewed 9.3k times · Source

Does Redshift support JSON fields, like Postgresql's json data type? If so what do I do to use it?

Answer

John Rotenstein picture John Rotenstein · Sep 23, 2015

You can store JSON in Amazon Redshift, within a normal text field.

There are functions available to extract data from JSON fields, but it is not an effective way to store data since it doesn't leverage the full capabilities of Redshift's column-based architecture.

See: Amazon Redshift documentation - JSON Functions

Related questions

How do I POST JSON data with cURL?

I use Ubuntu and installed cURL on it. I want to test my Spring REST application with cURL. I wrote my POST code at the Java side. However, I want to test it with cURL. I am trying to post …

Read More
What is the correct JSON content type?

I've been messing around with JSON for some time, just pushing it out as text and it hasn't hurt anybody (that I know of), but I'd like to start doing things properly. I have seen so many purported "standards" for …

Read More
Why can't Python parse this JSON data?

I have this JSON in a file: { "maps": [ { "id": "blabla", "iscategorical": "0" }, { "id": "blabla", "iscategorical": "0" } ], "masks": [ "id": "valore" ], "om_points": "value", "parameters": [ "id": "valore" ] } I wrote this script to print all of the JSON data: import json from pprint import pprint …

Read More