1
-
Hi Amy,
Yes, setting the GMT offset in the tenant will apply to all of your timestamp fields. The setting change does require restarting Analytics service. Alternatively, you can adjust time zones on a field-by-field basis with the addMinutes() function in formula column or insight. A more full-featured timezone function is on the product roadmap.
Thanks,
Dustin
-
Dustin Basil is it valid on most recent incorta versions?
-
Siva Kowsika No, this is not valid on recent versions. Incorta will reflect the timezone of the server it is installed on. To change the displayed timezone, you can either change the server OS timezone or pass desired timezone to the JVM running Incorta and perform a staging load of all Schemas. I recommend customers not comfortable with this process reach out to Incorta support for more detail or assistance. Steps below:
The steps to change the JVM timezone is as below:
1. backup the file 'startService.sh' located under '<incorta_installation_path>/IncortaNode'
2. edit the file changing the line below
from:export JAVA_OPTS="-Xms"$memorySize" -Xmx"$memorySize" -Dfile.encoding=UTF-8"
To:
export JAVA_OPTS="-Xms"$memorySize" -Xmx"$memorySize" -Dfile.encoding=UTF-8" -Duser.timezone=America/Los_Angeles
3. the above change to be done on both loader and analytics nodes.
4. restart the services.
5. do a full load from staging
-
