Getting Started with Amazon Redshift Spectrum - Amazon Redshift

Getting Started with Amazon Redshift Spectrum

In this tutorial, you learn how to use Amazon Redshift Spectrum to query data directly from files on Amazon S3. If you already have a cluster and a SQL client, you can complete this tutorial in ten minutes or less.

Note

Redshift Spectrum queries incur additional charges. The cost of running the sample queries in this tutorial is nominal. For more information about pricing, see Redshift Spectrum Pricing.

Prerequisites

To use Redshift Spectrum, you need an Amazon Redshift cluster and a SQL client that's connected to your cluster so that you can execute SQL commands. The cluster and the data files in Amazon S3 must be in the same AWS Region. For this example, the sample data is in the US West (Oregon) Region (us-west-2), so you need a cluster that is also in us-west-2. If you don't have an Amazon Redshift cluster, you can create a new cluster in us-west-2 and install a SQL client by following the steps in Getting Started with Amazon Redshift.

Steps to Get Started

To get started using Amazon Redshift Spectrum, follow these steps: