AWS – Amazon Redshift announces support for unloading data to JSON files
Amazon Redshift adds support for unloading SQL query results to Amazon S3 in JSON format, a lightweight and widely used data format that supports schema definition. With the UNLOAD command in Amazon Redshift, you can now use JSON in addition to already supported delimited text, CSV, and Apache Parquet formats.
Read More for the details.