Connecting to an Amazon Redshift data warehouse using SQL client tools
You can connect to Amazon Redshift data warehouses from SQL client tools over Java Database Connectivity (JDBC), Python, and Open Database Connectivity (ODBC) connections. Amazon Redshift doesn't provide or install any SQL client tools or libraries. To use these tools or libraries to work with data in your data warehouses, install them on your client computer or Amazon EC2 instance. You can use most SQL client tools that support JDBC, Python, or ODBC drivers.
Use the following sections to walk through the process of configuring your client computer or Amazon EC2 instance to use a JDBC, Python, or ODBC connection. They also discuss related security options for the client connection to the server. Additionally, find information about setting up and connecting from SQL client tools, such as SQL Workbench/J, a third-party tool, and Amazon Redshift RSQL. You can try these tools if you don't have a business intelligence tool to use yet. You can also use this section to learn about connecting to your data warehouse programmatically. Finally, if you encounter issues when attempting to connect to your data warehouse, you can review the troubleshooting information in this section to identify possible solutions.
Topics
- Configuring connections in Amazon Redshift
- Configuring security options for connections
- Connecting from client tools and code
- Connecting with SQL Workbench/J
- Connect to your data warehouse programmatically
- Using an authentication profile to connect to Amazon Redshift
- Troubleshooting connection issues in Amazon Redshift