Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Redshift to JSON

Hi,

How to make redshift table data to json array format , with nested array structure.

Thanks,

Mathan

1 Community Answers

Matillion Agent  

Arawan Gajajiva —

Hi Mathan! Just to clarify your question, are you asking how to take data that is stored in a Redshift table and unload into a JSON array?

If that is your intention, I believe the method would be to unload the data from Redshift, which will be in CSV format. Then, you would need to convert that CSV to JSON. There are a few ways to do that, such as using Python. However, i do not believe there is a native way to export data from Redshift directly into a JSON structure.

Hope this helps?
Arawan

Post Your Community Answer

To add an answer please login