Hello everyone. I'm currently tasked with working on a dashboard project for my company, which requires me to perform a series of queries involving my company's database (built using MongoDB). On all the tables where the column is an integer and is semantically represented as a timestamp, I don't understand why there is no option to Cast to a Specific Data Type in these cases?
I've read the guide for this one (Metadata editing) and it doesn't show any help regarding these instances either. Would love to hear from you all regarding this matter. Thanks!
Hi, I would also like to cast to other types that aren't available in the settings e.g. text.
My use case: I've got tables that use enums and other tables that use text fields. I am unable to join an enum with a text field with the editor.
ERROR: operator does not exist: text = currency_code_enum
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Casting my enums into text in the Metabase DB settings would fix this issue.