amazon-redshift-python-driver icon indicating copy to clipboard operation
amazon-redshift-python-driver copied to clipboard

Using IDC BrowserAuthPlugin to connect to Redshift

Open bpatchin1 opened this issue 1 year ago • 1 comments

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

bpatchin1 avatar Oct 23 '24 22:10 bpatchin1

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

khuston avatar May 20 '25 22:05 khuston