View a markdown version of this page

Prerequisites for using Amazon Redshift to analyze messages - Amazon Simple Notification Service
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 (PDF).

Prerequisites for using Amazon Redshift to analyze messages

Before you begin, make sure you've addressed all prerequisites in Prerequisites for subscribing Firehose delivery streams to Amazon SNS topics. You also need a SQL query tool. Amazon Redshift doesn't provide or install any SQL client tools or libraries. You must install one that you can use to access the Amazon Redshift clusters that contain your Amazon SNS notifications. This tutorial uses SQL Workbench/J, a free, DBMS-independent, cross-platform SQL query tool.

To install SQL Workbench/J

  1. Review the SQL Workbench/J software license.

  2. From the SQL Workbench/J website, download the appropriate package for your operating system.

  3. Use the Installing and starting SQL Workbench/J instructions to install SQL Workbench/J.

  4. From Configure a JDBC Connection, download an Amazon Redshift JDBC driver. This driver lets SQL Workbench/J connect to your cluster.