Posted On: Aug 8, 2018
You can now use HAQM Redshift to directly query nested data in Apache Parquet, Apache ORC, JSON and HAQM Ion file formats stored in external tables in HAQM S3. Redshift Spectrum, a feature of HAQM 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 HAQM 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).