I changed Looker database connection from fast access to Athena. However the fast access is using spark SQL, which is no longer work in Athena. The sql: from_unixtime(unix_timestamp(${TABLE}.dt,"yyyyMMdd")) works with fast access but not in Athena. So I would like to find the equivalent function for this in AWS athena, which return the same result in same data type.