aws / aws/amazon-redshift-jdbc-driver
Issues connecting to Redshift Serverless via DBeaver and DataGrip
- 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:
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
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