Skip to content

Using IDC BrowserAuthPlugin to connect to Redshift #241

Description

@bpatchin1

Driver version

2.0.0

Redshift version

([1372],)

Client Operating System

MacOS

Python version

Python 3.12.4

Table schema

not needed

Problem description

  1. Expected behaviour: Trying to connect to IDC using BrowserAuthPlugin, but running into various errors.
  2. Actual behaviour: Running into various errors
  3. Error message/stack trace: Error connecting to Redshift: {'S': 'FATAL', 'C': '28000', 'M': 'no PostgreSQL user name specified in startup packet', 'F': '/home/ec2-user/padb/src/pg/src/backend/postmaster/postmaster.c', 'L': '3518', 'R': 'ProcessStartupPacket'}
  4. Any other details that can be helpful:

-- CODE --

    conn = redshift_connector.connect(
        ssl=True,
        host=cluster_endpoint,
        port=port,
        database=database,
        idc_region=idc_region,
        provider_name='BrowserIdcAuthPlugin',
        issuer_url=issuer_url
        )

Looking for code that connects to Redshift using IDC BrowserAuthPlugin, seems like I am missing some important params

Activity

  1. khuston commented on May 20, 2025

    @khuston

    You have to use credentials_provider instead of provider_name. I had to peek at core.py to see this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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