Redshift Spectrum is a feature of Amazon Redshift that extends analytics to data stored in your Amazon S3 data lake, with no loading or transformations needed. Redshift Spectrum supports open data formats, such as Avro, CSV, Grok, Ion, JSON, ORC, Parquet, RCFile, RegexSerDe, SequenceFile, TextFile, and TSV. You can query data across Redshift and S3 to obtain insights not possible by querying independent data silos.
Redshift Spectrum scales processing across thousands of nodes to give you high concurrency and fast performance, regardless of data size and query complexity. Redshift Spectrum gives you the freedom to store your data where you want, in the format you want, and have it available for processing when you need it. To learn more, visit aws.amazon.com/redshift/spectrum.
With the latest release, Amazon Redshift Spectrum is available across 14 regions globally: 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).