Data Science, Analytics, Databricks, Data Cleaning.
timestamp using the CAST and DATE_FORMAT functions. CREATE OR REPLACE TEMP VIEW users_clean2 AS ( with new_date_format as ( SELECT *, user_first_touch_timestamp / 1e6 AS first_touch1, CAST(user_first_touch_timestamp / 1e6 AS timestamp) AS first_touch_timestamp FROM users_clean ) select user_id,