Amazon Redshift User Manual

5. In the Username and Password boxes, type the master user name and password. Select the
Autocommit check box. When all the settings are as you want them, click OK to save the profile.
6. If you loaded the sample tables and data from the Amazon Redshift Getting Started Guide, you can
test your connection by typing the following query into the Statement window:
select * from users order by userid limit 100;
If your connection is successful, a listing of records appears in the Results tab.
Alternatively, you can use the following query to test your connection.
select * from information_schema.tables;
API Version 2012-12-01
102
Amazon Redshift Management Guide
Setting Up the SQL Workbench Client

Amazon Redshift Specifications

General

Provider	Amazon Web Services (AWS)
Query Language	SQL
Data Storage	Columnar storage
Security	Encryption at rest and in transit, VPC, IAM
Backup	Automated and manual snapshots
Deployment	Cloud-based
Type	Cloud-based data warehouse service
Primary Use	Data warehousing, analytics
Integration	Integrates with AWS services, BI tools, and ETL tools
Pricing Model	On-demand and reserved instance pricing
Data Compression	Columnar storage with data compression
Performance Optimization	Query optimization