Making a custom attribute unique

I finally figured out that this is a feature that needs to be enabled for each tenant. If anyone comes across this question, please raise a support ticket asking to enable the feature.