Amazon Redshift User Manual

select * from information_schema.tables;
To use SQL Workbench/J with an ODBC driver
1. Install the ODBC driver on your system. In this example, we're using a 64-bit Unicode driver.
a. Unzip the driver package downloaded in Step 3 of To set up SQL Workbench/J (p. 96) and then
install the driver by using the .MSI package.
b. In the Amazon Redshift console, click the name of your cluster, and write down or copy the
ODBC URL from the Configuration pane.You will use portions of the URL string in step e.
c. In the Control Panel, open the Administrative Tools icon, and then double-click the Data Sources
(ODBC) icon.
d. In the ODBC Data Source Administrator dialog box, click System DSN. Click Add. Select the
Unicode driver, and then click Finish.
API Version 2012-12-01
99
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