Connect Amazon Redshift

Prerequisites

You have an Amazon Redshift provisioned cluster or serverless workgroup.
You have Redshift connection details for Skoot (Host, Port, Database, Username, Password).
The Redshift user has read access to the schemas and tables Skoot should use.
Skoot can reach your Redshift endpoint over the network.

Step 1 - Create a Read-Only Redshift User

Use a dedicated Redshift user for Skoot. Avoid shared admin credentials.

Run the grants from an admin SQL client, replacing the inputs first:


-- Create a dedicated user.
CREATE USER skoot_readonly_user PASSWORD 'replace_with_strong_password';
 
-- Allow the user to connect and inspect the schemas you expose.
GRANT USAGE ON SCHEMA my_schema TO skoot_readonly_user;
 
-- Allow reads on existing tables and views.
GRANT SELECT ON ALL TABLES IN SCHEMA my_schema TO skoot_readonly_user;
 
-- Optional: grant reads on future tables in the schema.
ALTER DEFAULT PRIVILEGES IN SCHEMA my_schema
GRANT SELECT ON TABLES TO skoot_readonly_user;

Repeat the schema grants for each schema Skoot should access.

Step 2 - Find Your Redshift Endpoint

For a provisioned Redshift cluster, use the cluster endpoint from the Redshift console.

For Redshift Serverless, use the workgroup endpoint from the Redshift console.

Provisioned clusters and serverless workgroups use the same Skoot connection fields:

Host
Port (Redshift commonly uses 5439)
Database
Username
Password
Use SSL

Step 3 - Network Access

If your Redshift endpoint is private or protected by security groups, allow Skoot network access before connecting.

If needed, allowlist Skoot public egress IP from Data Sources in your AWS security group, firewall, or network access layer.

If your Redshift endpoint is private, use private networking instead of public allowlisting.

Step 4 - Optional: Redshift Spectrum Access

If you use Redshift Spectrum external schemas, grant Skoot access to the external schema and its tables:


GRANT USAGE ON SCHEMA my_external_schema TO skoot_readonly_user;
GRANT SELECT ON ALL TABLES IN SCHEMA my_external_schema TO skoot_readonly_user;

Connect in Skoot App

After Redshift setup is complete:

Click Amazon Redshift in Available Data Sources section Amazon Redshift Connection .
Fill these fields exactly:
- Connection Name
- Host
- Port
- Database
- Username
- Password
- Use SSL
- Query Timeout (ms) (minimum 1000)
Save the connection.
Confirm status is Connected.