Change data type of collection's column


event sync creates collection field’s types incorrectly. For example, uid should be int32, but it’s string.

It makes running queries extremely uncomfortable. How can I change column data type?

Is there way to turn on index? Tried with Compass but indexation is not being saved.

About creating indexes, you could try with mongo db commands directly from a programming language.

About changing a column type, it may not be possible:

You could create an additional column and to set data for that column on a hook like beforeSave.

Is it ok to add custom column in collection where moralis puts events sync data?

I think that you can do it, a custom column should be only a new key for an object, some objects can not have that key set initially and the value for that column will be undefined initially in the interface.