Solve for users in Cognito that have the same Email Address

[mmarcotte]

Our current Cognito configuration allows users to have the same email address with different combinations of uppercase and lowercase letters. Stories are soon to be worked on that allow users to signup and authenticate within the application that will help us begin the normalization process for these users.

When we do this, we are going to have a tricky time authenticating users who have the same email address more than once in the database. The login process is going to find accounts in Cognito that match the email address provided, regardless of case. If there are more than one, then it becomes confusing to figure out which account to log the user into.

So, we need to dedupe the Cognito User Pool of Email Addresses.

AC

• List of users identified that have multiple accounts in Cognito with the same email address.
• Users migrated to new Email addresses that have the same email address
• For all of the users in Cognito, check to see if they have a corresponding record in the Database with the same Email address. We recently found one where there was a mismatch.