Transformation rules inside mapper snap not exported to output file
- 4 years ago
The Snowflake snaps have a setting called
Handle Timestamp and Date Time Data
. Unfortunately, its default setting,Default Date Time format in UTC Time Zone
, has less-than-ideal behavior. The object type of the timestamp objects is java.sql.Timestamp, which will result in the odd inconsistencies you’re seeing between validation vs execution, and it’s also not a very usable type on the SnapLogic expression language.I suggest changing this setting to the other option,
SnapLogic Date Time format in Regional Time Zone
. This will convert the timestamps to the type org.joda.time.DateTime, the type that the SnapLogic EL functions are designed to deal with.This option will also produce a DateTime with the default time zone of the plex node, which can complicate things if the node’s default timezone isn’t UTC. But based on what you’ve shown, your node’s default timezone is UTC, so this shouldn’t be a problem for you, fortunately.
After changing that setting, try using an expression like
$Expire_Date.toLocaleDateTimeString({format: "yyyy-MM-dd'T'HH:mm:ss'Z'"})
.Hope that helps.