aws / aws/amazon-redshift-jdbc-driver

Issues connecting to Redshift Serverless via DBeaver and DataGrip

Open
#139 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
71
Forks
42
PR merge metrics
No merged PRs in 30d

Description

What I have:

- a Redshift Serverless instance (publicly accessible)
- an admin user
- a user/pass user
- me, an IAM user

I then try to connect to the workgroup using the following URL:
```
jdbc:redshift:iam://[wg-name].[account].[region].redshift-serverless.amazonaws.com:5439/dev?profile=[my profile]
```

I get the following error in dbeaver:
Image

And this is DataGrip (using no-auth just uri and using the builtin `AWS Credentials` auth):
```
DBMS: Amazon Redshift (no ver.)
Case sensitivity: plain=mixed, delimited=exact
[99999] Something unusual has occurred to cause the driver to fail. Please report this exception:Invalid property format: no = character is found on line 15
Invalid property format: no '=' character is found on line 15.
```

notes:
- Both have SSL turned on.
- Both tools can connect using the non `iam` jdbc URL with user/pass auth, where the values are pulled from `aws redshift-serverless get-credentials --workgroup-name[wg-name]`
- other user/pass users work fine
- Console query access via `iam federated access` works fine too.

How can I correct the tools settings to use the `iam` profile auth correctly?

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the JDBC URL in DBeaver and DataGrip with the Redshift Serverless workgroup and IAM profile settings shown. Read the driver’s IAM authentication and connection-property handling around the “no = character” error, then verify the correction by connecting successfully with the IAM profile while user/password connections continue to work.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.