User guide

Step 5: Create Tables, Upload Data, and Try Example Queries
For information about creating tables, uploading data, and issuing queries, go to the Amazon Redshift
Getting Started Guide.
Step 6: Delete Your Sample Cluster
After you have launched a cluster and it is available for use, you are billed for the time the cluster is
running, even if you are not actively using it. When you no longer need the cluster, you can delete it.
When you delete a cluster, you must decide whether to create a final snapshot. Because this is an exercise
and your test cluster should not have any important data in it, you can skip the final snapshot.
To delete your cluster, type the following command:
aws redshift delete-cluster --cluster-identifier examplecluster --skip-final-
cluster-snapshot
Congratulations! You successfully launched, authorized access to, connected to, and terminated a cluster.
Connecting to a Cluster
You can connect to Amazon Redshift clusters from SQL client tools over Java Database Connectivity
(JDBC) and Open Database Connectivity (ODBC) connections. Amazon Redshift does not provide or
install any SQL client tools or libraries, so you must install them on your client computer or Amazon EC2
instance to use them to work with data in your clusters.You can use most SQL client tools that support
JDBC or ODBC drivers.
You can use this section to walk through the process of configuring your client computer or Amazon EC2
instance to use a JDBC or ODBC connection, and related security options for the client connection to the
server. Additionally, in this section you can find information about setting up and connecting from two
example third-party SQL client tools, SQL Workbench/J and psql, if you don't have a business intelligence
tool to use yet.You can also use this section to learn about connecting to your cluster programmatically.
Finally, if you encounter issues when attempting to connect to your cluster, you can review the
troubleshooting information in this section to identify possible solutions.
Topics
• Configuring Connections in Amazon Redshift (p. 138)
• Connecting to Clusters From Client Tools and Code (p. 162)
• Troubleshooting Connection Issues in Amazon Redshift (p. 173)
Configuring Connections in Amazon Redshift
Use this section to learn how to configure JDBC and ODBC connections to connect to your cluster from
SQL client tools.This section describes how to set up JDBC and ODBC connections and how to use
Secure Sockets Layer (SSL) and server certificates to encrypt communication between the client and
server.
Topics
• JDBC and ODBC Drivers for Amazon Redshift (p. 139)
• Finding Your Cluster Connection String (p. 139)
• Configure a JDBC Connection (p. 140)
API Version 2012-12-01
138
Amazon Redshift Management Guide
Connecting to a Cluster