Timestamp column returned as milliseconds not datetime format (Snowflake)

This behavior is not consistent but happens most of the times - when querying a Snowflake DB table in redash using select * - the TIMESTAMP columns are returned in milliseconds (e.g. 1607436310000)
but when the same field is queried specifically (e.g. select <timestamp_column_name> from :wink: - the result returned as expected (08/12/20 14:05:10.000).

I need the results always to return in the later format and not in milliseconds when using select *.