Getting started with Amazon Redshift Spectrum - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

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.


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.


To use Redshift Spectrum, you need an Amazon Redshift cluster and a SQL client that's connected to your cluster so that you can run SQL commands. The cluster and the data files in Amazon S3 must be in the same Amazon 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.

Getting started with Redshift Spectrum using Amazon CloudFormation

As an alternative to the following steps, you can access the Redshift Spectrum DataLake Amazon CloudFormation template to create a stack with an Amazon S3 bucket that you can query. For more information, see Launch your Amazon CloudFormation stack and then query your data in Amazon S3.

Getting started with Redshift Spectrum step by step

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