Insert a json in redShift using query

Question

I'm trying to insert data into redshift table using this SQL query:

insert into temp(JSON)({"name":"abc","lname":"xyz"});

but it does not work, I get an error:

Syntax error

Is there any way to insert json data into redshift using a query?

I want to insert a whole json object into query instead of passing key and values

K_at_play · Accepted Answer · 2022-08-26 23:33:03Z

3

INSERT INTO temp
  (JSON)
VALUES
  (JSON_PARSE('{"name":"abc","lname":"xyz"}'));

answered Aug 26, 2022 at 23:33

K_at_play

414 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yusuf Hassan · Accepted Answer · 2017-10-11 13:26:31Z

1

You may simply execute:

insert into temp values('{"name":"abc","lname":"xyz"}');

JSON as a datatype is not supported on Redshift - Amazon Redshift Documentation

answered Oct 11, 2017 at 13:26

Yusuf Hassan

2,0131 gold badge14 silver badges21 bronze badges

Side-note. There are functions such as JSON_EXTRACT_ARRAY_ELEMENT_TEXT that can then use the JSON data stored in this way.

Update -> You can insert semi-structured data into redshift with the SUPER data type: docs.aws.amazon.com/redshift/latest/dg/r_SUPER_type.html.