Redshift

Redshift is generally available in the DataSquares connection wizard.

1. In DataSquares, open Data Sources and choose Add data source.

2. Pick Redshift in the connector picker (search or browse by category).

3. Fill in the connection details below, then test the connection and save.

Connection details

Field	What to enter
Host	The hostname or IP address of your Redshift server.
Port	Prefilled with 5439 (the Redshift default) — change it if your server listens elsewhere.
Database	The database to connect to.
Username / Password	Credentials for a user with read access to the tables you want to analyze.
TLS	Enable if your server requires an encrypted connection.

Grant the connection user read-only access — DataSquares only ever reads from your source.

Grant read-only access

CREATE USER datasquares PASSWORD '********';
GRANT USAGE ON SCHEMA public TO datasquares;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO datasquares;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO datasquares;

Reachability

Redshift clusters are VPC-resident: either mark the cluster publicly accessible and allowlist the DataSquares server’s IP in its security group, or provide a private route. The endpoint host comes from the cluster’s details page; the default port is 5439.

Common errors

Error	Cause / fix
timeout	security group doesn’t allow the DataSquares IP on 5439, or the cluster isn’t publicly accessible
permission denied for schema	missing USAGE on the schema (a common Redshift trip-up — SELECT alone isn’t enough)

Related

• Connector catalog — everything DataSquares connects to.
• Quickstart — from connection to shared dashboard.