Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can you store JSON fields on Redshift?

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

like image 837
Some Guy Avatar asked Sep 22 '15 17:09

Some Guy


People also ask

Can redshift store JSON data?

Amazon Redshift supports the parsing of JSON data into SUPER and up to 5x faster insertion of JSON/SUPER data in comparison to inserting similar data into classic scalar columns.

Can you store JSON in a database?

You can store JSON documents in SQL Server or SQL Database and query JSON data as in a NoSQL database.

Is JSON a good way to store data?

JSON is perfect for storing temporary data. For example, temporary data can be user-generated data, such as a submitted form on a website. JSON can also be used as a data format for any programming language to provide a high level of interoperability.

Does redshift support unstructured data?

Unstructured data – Data in Amazon Redshift must be structured by a defined schema, rather than supporting arbitrary schema structure for each row. If your data is unstructured, you can perform extract, transform, and load (ETL) on Amazon EMR to get the data ready for loading into Amazon Redshift.


1 Answers

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

like image 123
John Rotenstein Avatar answered Sep 28 '22 10:09

John Rotenstein