How to use native user to connect to redshift serverless

[mdeshmu]

I am trying to connect to Redshift serverless using database authentication with temporary credentials fetched using IAM permissions similar to #123 but redshift-connector doesn't fetch temporary credentials for the user mentioned in conect_args. It fetches credentials for the IAM role of the aws service on which our app is running.

{   
	"connect_args": {    
		"iam": true,    
		"is_serverless": true,    
		"serverless_acct_id": "123455567",    
		"serverless_work_group": "my-workgroup",    
		"db_user": "my_user"    
	}    
}    

How to connect to Redshift serverless with database (native user) authentication using redshift_connector?

[Brooke-white]

Hi @mdeshmu , If you're looking to use native authentication (user/password), you can do so as follows:

connect_args = {
host='my-serverless-endpoint',
port=5439,
user='my_user',
password='my_password'
}

When performing IAM authentication, redshift-connector uses this boto3 API endpoint for retrieving temporary credentials. This API endpoint returns a database user and temporary database password used for authentication with Redshift.