Skip to content

Issues connecting to Redshift Serverless via DBeaver and DataGrip #139

@GitToby

Description

@GitToby

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions