Set an auto generate column as the user identity (in the user table)

I am looking into user management. I’m not keen on using email as an user identity as emails can change. I wanted to have an auto incremented column to use as a user_id. However I can’t set such a column as an “identity” on the user table. schema “table editor” says Identity columns must be of type string, int, or double which the auto increment column seems to be as its datatype is “AUTO NUMBER (AUTO INCREMENT)”. Is this possible ?


Hi @hharrington ,

Unfortunately it is impossible to select auto-increment columns as identity.
I have created an internal ticket to investigate if it will be possible to add support for this type column as identity.

Regards, Andriy

Hello @hharrington

You can now select the Auto Increment column as a user-identity column.