User guide

Test the SQL Workbench/J Connection
After you configure your JDBC or ODBC connection, you can test the connection by running an example
query.
1. If you loaded the sample tables and data from the Amazon Redshift Getting Started, 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.
2. Alternatively, you can use the following query to test your connection.
select * from information_schema.tables;
API Version 2012-12-01
165
Amazon Redshift Management Guide
Connecting to Clusters From Client Tools and Code