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.