Posted On: Aug 8, 2018

You can now use Amazon Redshift to directly query nested data in Apache Parquet, Apache ORC, JSON and Amazon Ion file formats stored in external tables in Amazon S3. Redshift Spectrum, a feature of Amazon Redshift, enables you to use your existing Business Intelligence tools and intuitive and powerful SQL extensions to analyze both scalar and nested data stored in your Amazon S3 data lake.

Nested data support with Redshift Spectrum enables you to query complex data types such as struct, array, or map, without having to transform or load your data. This simplifies existing data ingestion processes and reduces the time-to-insight.

For more information on how to get started with nested data, please see our documentation.

Support for nested data is available with the latest release 1.0.3077 in the following AWS Regions: US East (N. Virginia, Ohio), US West (Oregon, N. California), Canada (Central), South America (Sao Paulo), EU (Frankfurt, Ireland, London), Asia Pacific (Mumbai, Seoul, Singapore, Sydney, Tokyo).