Tranform date time column to UTC timezone, and use it as 'timestamp' in timestampSpec


I have a need where I need to convert the date time to a particular time zone and then use that as ‘timestamp’ column in timestampSpec.

Each record to ingest has three fields i.e. date_time, page_name, page_event

Here date_time is in the format yyyy-MM-dd HH:mm:ss and is in PST timezone.

Question - How can I convert this PST time to UTC time and then use the newly added column **** as ‘timestamp’ in timestampSpec. I am trying something like below, but it is not working.

“transformSpec”: {
“filter”: ,
“transforms”: [
“type”: “expression”,
“name”: “date_time_utc”,
“expression”: “timestamp_format(date_time,‘yyyy-MM-dd HH:mm:ss’,‘UTC’)”

“timestampSpec”: {

“format”: “auto”,

“column”: “date_time_utc”



Thank you in advance.