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!