Can Redshift authenticate to AWS Managed AD and how?

Question

If a customer wanted to use AWS Managed AD, how would Redshift be able to use it for authentication?

I am guessing that one could install ADFS on Windows-EC2 and connect it to Managed AD.  Then one would setup the Redshift driver to federate to the self-managed ADFS on EC2.  Is this correct?  Has anyone ever done this and tested it?

Is there a better way?

Accepted Answer

There is a walk through blog post on configuring AD FS specifically targeted at Redshift, I would check and see if this workflow meets your requirements - https://aws.amazon.com/blogs/big-data/federate-database-user-authentication-easily-with-iam-and-amazon-redshift/

Can Redshift authenticate to AWS Managed AD and how?

Contenido relevante