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

user_3292849 0
Viewed 809

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?

datagrip mongodb uuid binary database
1 Answers

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

user_78040600
Related