aws / aws/amazon-redshift-python-driver
Using IDC BrowserAuthPlugin to connect to Redshift
- Dominant language
- Python
- Stars
- 220
- Forks
- 86
- PR merge metrics
- No merged PRs in 30d
Description
## 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
Contributor guide
Research direction
Start with the redshift_connector.connect call and the BrowserIdcAuthPlugin parameters shown in the issue. Trace how those arguments form the startup packet and compare the required IDC authentication inputs with the reported missing PostgreSQL user error. Done means the required connection parameters are identified and a working or clearly reproducible connection example is provided.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100