When you run a mapping in advanced mode to read from or write to fields of the Date and Timestamp data types in the Parquet or Avro file formats, the time zone defaults to the Secure Agent host machine time zone.

To change the Date and Timestamp to the UTC time zone, you can either set the Spark properties globally in the Secure Agent directory for all the tasks in the organization that use this Secure Agent, or you can set the Spark session properties for a specific task from the task properties:  

To set the properties globally, perform the following tasks:

Add the following properties to the
<Secure Agent installation directory>/apps/At_Scale_Server/41.0.2.1/spark/custom.properties
directory:
infacco.job.spark.driver.extraJavaOptions=-Duser.timezone=UTC
infacco.job.spark.executor.extraJavaOptions=-Duser.timezone=UTC
Restart the Secure Agent.

To set the properties for a specific task, navigate to the Spark session properties in the task properties, and perform the following steps:

When you read data of the double data type from a Google Cloud Storage JSON file and write data to a Google Cloud Storage flat file target, data corruption occurs in the target for the corresponding data of the Double data type.