Posted On: Dec 21, 2017
You can now leverage Amazon Redshift Spectrum to query DATE data type stored in Optimized Row Columnar (ORC) and text files in Amazon S3. For example, you can use the DATE data type to query clickstream data within specific time windows to gain insights into business trends. To learn more, visit our documentation.
Amazon Redshift Spectrum is a feature of Amazon Redshift that extends analytics to data stored in your Amazon S3 data lake using the open file formats you already use, with no loading or transformations needed. You can seamlessly use the same standard SQL of Amazon Redshift and the Business Intelligence tools you use today. Amazon Redshift Spectrum applies sophisticated query optimization and scales processing across potentially thousands of nodes to give you high concurrency and fast results – even with large data sets and complex queries. Amazon 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.
Amazon Redshift Spectrum is available in AWS Regions US West (Northern California), US East (Northern Virginia), US East (Ohio), US West (Oregon), Canada (Central), EU (Frankfurt), EU (Ireland), EU (London), Asia Pacific (Seoul), Asia Pacific (Singapore), Asia Pacific (Sydney), and Asia Pacific (Tokyo).