Hey, quick question, does Elementary support SQL e...
# community-support
a
Hey, quick question, does Elementary support SQL expressions in the 'timestamp_column' configuration? Or does it have to be column which already exists in a table? My timestamp column is a COALESCE of two different columns in my case.. Also, is elementary able to handle timestamps in unix epoch format?
l
Also, is elementary able to handle timestamps in unix epoch format?
Based on the sql code generated by elementary I would say yes, internally elementary tries to cast column to timestamp, I think this is the macro: https://github.com/elementary-data/dbt-data-reliability/blob/32bc9c8c2b787ae98f1d7[…]c1269a/macros/utils/data_types/try_cast_column_to_timestamp.sql
👍 1