Search code examples
databasemongodbbinaryuuiddatagrip

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


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

enter image description here

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


Solution

  • 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.

    enter image description here