Hi @SamGreene, You’re on the right track with using the TO_TIMESTAMP
function. However, you might be encountering issues due to the format of your timestamp string. The string ‘20240603164746563’ seems to represent a timestamp down to the millisecond. If you’re only interested in the second-level precision, you can indeed use the LEFT
function to trim the string.
The error message you’re seeing suggests that your table schema requires the timestampNtz
feature to be manually enabled. This feature is used for handling timestamps without timezone information. However, since you’re working with a Live Table, you’re unable to run the ALTER TABLE
command to enable this feature.
It might be worth filing a Databricks support ticket for more specific guidance on this issue.