Posted On: Feb 16, 2022

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.

Using JSON format with your UNLOAD statement, you can write your query results to JSON files with each line containing a JSON object, representing a full record in the query result. Amazon Redshift supports writing nested JSON data when your query result contains columns using SUPER, the native Amazon Redshift data type to store semi-structured data or documents as values.

Support for exporting JSON data using UNLOAD is available in all AWS commercial Regions. Refer to the AWS Region Table for Amazon Redshift availability. For more information or to get started with Amazon Redshift, see the documentation or read this blog post.