Hello all. I am trying to connect datahub to redshift using IAM Auth. So basically what this means is that I am not going to supply a password to the user, rather set up an endpoing using aws-vault. However, I so far I am not being successfull. Does anyone have a similar setup that could help me?

Hey, It seems like we should use

redshift_connector

instead of psycopg2 to support iam-based authentication. https://sqlalchemy-redshift.readthedocs.io/en/latest/ The redshift_connector has the iam capability -> https://github.com/aws/amazon-redshift-python-driver If switch to use this driver later on or if you want to can try to switch and contribute back

Hello. Thanks a lot, I will try it!