connector

Redshift

Amazon's managed data warehouse, Postgres-compatible wire protocol.

Connection fields

Field	Required	Description
`host`	Yes	Hostname or IP address of the Redshift cluster endpoint.
`port`	No	Defaults to 5439.
`user`	Yes	Username to authenticate with.
`password`	No	Password for user.
`dbname`	Yes	Database name to connect to.
`sslmode`	No	One of "disable", "prefer" (default), or "require".

Redshift speaks the Postgres wire protocol, so this connector is the Postgres connector registered under a different type name and default port — Redshift-specific SQL dialect differences from standard Postgres aren't specially validated.

Example configuration

{
  "host": "my-cluster.abc123.us-east-1.redshift.amazonaws.com",
  "port": 5439,
  "user": "arcodash_reader",
  "password": "••••••••",
  "dbname": "analytics",
  "sslmode": "require"
}

Caveats

arcodash needs network access to reach the cluster endpoint, so the cluster's security group must accept connections from the internet. arcodash doesn't publish a fixed set of outbound addresses to allowlist — enable SSL/TLS rather than relying on IP filtering.