Page 1 of 1

RedShift Connection with dbgroup and role

Posted: Wed 03 Aug 2022 07:39
by johan swart
Hi,

I would like to connect to a AWS Redshift database using the Devart UniDAC Redshift Provider and connection.
I have managed to figure out how to do it in ODBC with the Redshift (64 bit) ODBC driver, and can use theODBC provider to connect.

I would however like to connect directly.

To connect to the database the login is handled via https url and then one needs to specify a role and a dbgroup. I do not know how to specify the latter in the connector.

https://1drv.ms/u/s!At7PungYM9FrsKYz0om ... g?e=P2swvc

Any help to connect will be appreciated!!

Regards,
Johan
PS: I am using version 8.4.3

Re: RedShift Connection with dbgroup and role

Posted: Tue 06 Sep 2022 11:11
by jamecorbitt
Try to use a named profile in credentials.
awsume has an option to write the credentials to the file: awsume -o default role-profile-name will write them as [default] in ~/.aws/credentials.