Interfaces

Amazon Redshift has custom Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC) drivers you can download from the Connect Client tab of the console, which means you can use a wide range of familiar SQL clients. You can also use standard PostgreSQL JDBC and ODBC drivers. For more information about Amazon Redshift drivers, see Amazon Redshift and PostgreSQL in the Amazon Redshift Database Developer Guide.

Amazon Redshift provides a built-in Query Editor in the web console. The Query Editor is an in-browser interface for running SQL queries on Amazon Redshift clusters directly from AWS Management Console. It’s a convenient way for a database administrator (DBA) or a user to run queries as needed, or diagnose queries.

You can also find numerous examples of validated integrations with many popular BI and ETL vendors. In these integrations, loads and unloads execute in parallel on each compute node to maximize the rate at which you can ingest or export data to and from multiple resources, including S3, Amazon EMR, and DynamoDB. You can easily load streaming data into Amazon Redshift using Amazon Data Firehose, enabling near real-time analytics with existing BI tools and dashboards. You can locate metrics for compute utilization, memory utilization, storage utilization, and read/write traffic to your Amazon Redshift data warehouse cluster by using the console, or Amazon CloudWatch API operations.