@Max yeah just verified with our DB guy and he confirmed our RDS Aurora has this column unique otherwise it will not populate uniquely.
any other thoughts, why this is being treated as case insensitive why and we have this situation? I read in the thread of Case Sensitivity that their default scenario should be what’s expected to happen on our environment but it’s the other way around.
Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!