How to specify the time zone in the transfer destination column representing the time
  • 07 Dec 2022
  • PDF

How to specify the time zone in the transfer destination column representing the time

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

If you want to express the time in a specific time zone, such as Asia/Tokyo, in the forwarding destination specification column, you can achieve it by taking the following steps.

  1. In the target transfer settings, click Add Column in Item column settings on the "STEP2 Data Preview / Advanced Settings" output options tab.

* The following is an example when BigQuery is specified as the forwarding destination.

image.png

image.png

  1. Make the following settings for the added items.
  • Column name: < column name that you want to express in a specific time zone>
  • Data type:DATETIME or timestamp ※See supplement
  • Date format: <Any format> * Some data types do not require input.
  • Timezone: JST

    image.png
  1. Click on the Output option.

  2. Run the transfer job and confirm that the data transfer occurred in the specified time zone.

If you have any other questions or consultations about using the service, please contact Customer Success.

supplement

If the transfer job fails due to data type inconsistency, it may be resolved by setting the transfer mode to REPLACE in the transfer destination settings in "STEP1 Transfer Source / Destination Settings".


Was this article helpful?