How to specify the time zone in the destination column for time

summary

If you wish to use a specific time zone, such as Asia/Tokyo, in the destination column that indicates the time, you can do so by following the steps below.

1. Click "Add Column" in the "STEP2 Data Preview/Detailed Settings" Output Option tab of the Target Transfer Settings.

*The following is an example of specifying BigQuery as the forwarding destination

2. The following settings are made for the added items.

• Column name: .
• Data type: DATETIME or timestamp *See Supplemental
• Date format: *Not required for some data types.
• Time zone: JST
  　
  

3. Click Output Options.

4. Please run the transfer job and confirm that the data transfer took place in the specified time zone.

If you have any other questions or concerns, please contact Customer Success.

supplement

If a transfer job fails due to data type mismatch, the problem may be resolved by setting the transfer mode to REPLACE in the destination setting in "STEP1 Transfer source/destination setting".