Amazon Redshift

Overview

Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse from AWS. It uses columnar storage and a massively parallel processing (MPP) architecture to run analytical queries across large datasets, and integrates with the broader AWS ecosystem such as S3, Glue, and Redshift Spectrum. Redshift was originally derived from PostgreSQL and remains compatible with the PostgreSQL wire protocol, so standard Postgres clients can talk to it.

Driver

Crate: tokio-postgres
Version: 0.7

Connection fields

Field	Description
Host	Redshift cluster endpoint, e.g. `mycluster.abc123.us-east-1.redshift.amazonaws.com`.
Port	TCP port the cluster listens on. Redshift defaults to `5439`.
Database	Name of the database to connect to. New clusters default to `dev`.
User	Authentication username.
Password	Authentication password. Stored in the macOS Keychain.
SSL Mode	One of `disable`, `prefer`, `require`, `verify-ca`, or `verify-full`. Redshift clusters typically require SSL.
Options	Additional connection parameters as `key1=val1&key2=val2`.

All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. SeeSSH tunnels for details.

URI format

Instead of filling in each field individually, you can paste a connection URI into thePaste URI field. Arris parses the URI and populates all fields automatically. Paste the cluster endpoint AWS shows in the Redshift console.

textConnection URI

redshift://user:[email protected]:5439/dev?sslmode=require

SSL & TLS

Redshift uses the same five SSL modes as PostgreSQL. Because Redshift clusters generally enforce encryption, Arris defaults Redshift connections to require.

SSL Mode	Behavior
`disable`	Never use SSL. Not recommended for production.
`prefer`	Use SSL if available, fall back to unencrypted.
`require`	Always use SSL. Fail if the server does not support it.
`verify-ca`	Require SSL and verify the server certificate against a CA.
`verify-full`	Require SSL, verify the CA, and verify the server hostname matches the certificate.

Schema browser

Once connected, Arris fetches the full schema tree and organizes it into groups. The default schema filter is set to public, but you can add or remove schemas from the filter dropdown in the sidebar.

The schema tree displays the following object types, grouped by category:

Tables — regular tables and external (Spectrum) tables
Views — views and materialized views, including late-binding views
Routines — functions and stored procedures
Sequences — identity sequences
Triggers — table-level triggers
Indexes — index metadata exposed by the catalog

Double-click any table, view, materialized view, or external table to open it in a new tab with browse mode.

Supported SQL commands

Command	Notes
`SELECT`	Query data with `WHERE` filters, `JOIN`s, aggregates, and window functions.
`INSERT`	Insert single or multiple rows.
`UPDATE`	Update existing rows.
`DELETE`	Delete rows.
`CREATE` / `DROP`	Create and drop tables, views, and other schema objects.