Convert Timestamp from UTC to PST

[RajneelRam]

Hi Everyone, 

I am using data fusion to extract data which is loaded into BigQuery. From the source table, the datefield is stored as "TIMESTAMP_NTZ(9)" and currently its loading as a UTC format in BigQuery. I am trying to figure out, which syntax can be used in wrangler which converts the fields to PST.  

Sample of date stored in BigQuery: "2020-10-30T10:15:12Z[UTC]"

At the moment, I have tried a few variety of set-column, parse-as-simple-date, timestamp-to-datetime but not successful at the moment. 

I would appreciate any guidance if this conversion is possible. 

Thanks in advance!

RJ