How to display MongoDB UUID binary ID columns in String UUID format in Jetbrain's Datagrip

Question

Is there any way I can transform columns like this, directly into readable String UUID values inside the data view?

I would like to search directly for String UUID. Is this possible?

Answer 1

Yes, but you need to tell MongoDB driver which UUID format you want to use (Java legacy, C# legacy or Python legacy).

Go to datasource settings > Advanced tab and edit uuidRepresentation value.