Add support for passwords in SSM Parameter Store

[IanMeyers]

No description provided.

[bnusunny]

Hi Ian,

This is important for China regions because kms is not available there yet. I can work on this and send an PR.

If you already have an design in mind, please kindly share with me. :)

Harold

[bnusunny]

We can actually use IAM role to allow Lambda to access RedShift. RedShift can also use IAM role to gain access to S3. Using IAM will avoid to store AK/SK and password in DynamoDB.

@IanMeyers , is there any issue preventing us to use IAM in this solution?

[IanMeyers]

Hello - @bnusunny no issues preventing the use of Cluster IAM roles - you just need to add this information in the auth section.

[IanMeyers]

But I still think having support SSM parameter store makes sense.