How to connect Redshift to DBeaver in PostgreSQL

How do I connect Amazon Redshift to DBeaver?

Configure a JDBC connection in DBeaver so you can query Amazon Redshift clusters from the desktop SQL IDE.

Welcome to the Galaxy, Guardian!

Oops! Something went wrong while submitting the form.

Description

How do I add a Redshift connection in DBeaver?

Open DBeaver > Database > New Connection. In the driver list pick “Redshift.” Supply cluster endpoint, port (default 5439), database name, user, and password. Click “Edit Driver Settings” if the JDBC driver is missing; DBeaver will download it automatically.

Which JDBC URL and parameters should I use?

Use the format jdbc:redshift://<host>:<port>/<database>?ssl=true&tcpKeepAlive=true.SSL encryption is required; tcpKeepAlive prevents idle timeouts during long analysis sessions.

How can I test the connection quickly?

Click “Test Connection.” Green means success; red means network, credential, or security-group issues.Verify that the VPC security group allows inbound traffic from your IP on port 5439.

What query should I run first?

After connecting, run a simple sanity check: SELECT current_database(), current_user, version(); to confirm you are on Redshift.

How do I visualize ecommerce data after connecting?

Create a new SQL script tab and run an aggregate query, e.g., daily revenue from the Orders table.Use DBeaver’s results grid to filter, sort, and export to CSV.

Best practices for stable Redshift-DBeaver sessions?

Enable keep-alive, set Maximum number of connections to a reasonable value, and use Auto-commit for quick reads.For long-running ETL, turn off Auto-commit and commit manually.

How can I save and share the connection?

Right-click the connection > Edit > General > “Save password locally.” Export the connection as a .dbeaver file and share it securely; recipients can import it via File > Import > DBeaver > Project.

Why How to connect Redshift to DBeaver in PostgreSQL is important

How to connect Redshift to DBeaver in PostgreSQL Example Usage


-- Top-10 customers by lifetime spend
SELECT c.id,
       c.name,
       SUM(o.total_amount) AS lifetime_spend
FROM   Customers c
JOIN   Orders o ON o.customer_id = c.id
GROUP  BY c.id, c.name
ORDER  BY lifetime_spend DESC
LIMIT 10;

How to connect Redshift to DBeaver in PostgreSQL Syntax


jdbc:redshift://<host>:<port>/<database>?user=<user>&password=<password>&ssl=true[&tcpKeepAlive=true]

Parameter explanations:
<host>            – cluster endpoint, e.g., redshift-cluster.abc123.us-east-1.redshift.amazonaws.com
<port>            – 5439 by default
<database>        – target database, e.g., analytics
user              – IAM-mapped or local Redshift user
password          – user password
ssl               – must be true for encrypted transport
tcpKeepAlive      – optional; keeps idle connections alive

Example (ecommerce):
jdbc:redshift://rs-demo.us-east-1.redshift.amazonaws.com:5439/store?user=dw_readonly&password=s3cr3t&ssl=true&tcpKeepAlive=true

Common Mistakes

Skipping SSL in the JDBC URL. Redshift requires SSL; omitting it results in "connection refused" errors. Fix by appending ?ssl=true.
Leaving VPC security group closed. If port 5439 is not open to your IP, the connection times out. Whitelist your public IP or use a VPN.

Frequently Asked Questions (FAQs)

Can I use IAM credentials instead of a password?

Yes. Choose the "IAM" auth method in the connection dialog, install the AWS CLI, and configure your profile. DBeaver signs the request with temporary tokens.