Snowflake Data Cloud Connector

Back Next

Troubleshooting

When you run a mapping to write data from a string column that contains date and time information, the mapping writes date and time information incorrectly to the Snowflake target.: To resolve this issue, set the JVM option to
-DHonorInfaDateFormat=true
for the Secure Agent.

To configure the JVM option in Administrator, perform the following steps:

Select
Administrator
Runtime Environments
.
On the
Runtime Environments
page, select the Secure Agent machine that runs the mapping.
Click
Edit
.
In the
System Configuration Details
section, select
Data Integration Server
as the
Service
and
DTM
as the
Type
.
Edit the
JVMOption
system property and set the value to
-DHonorInfaDateFormat=true
.
Click
Save
.