@i2cute
Metabase cannot convert types - it will try to present the information in the type selected.
You need to convert the underlying text column to a date column with a database View or similar.
@flamber thanks so much for the reply. How metabase read unix timestamp then? Possible from admin page to convert unix timestamp direct or need custom sql?
@i2cute If your data is a string, then Metabase reads a string and sometimes the frontend might try to convert something in a few cases. If you want Metabase to be able to handle it as a timestamp, then create a database View - I have no idea how Druid works, so you’ll have to ask in a Druid forum for more help.