Time Zones in Automated Data Distribution v2 for Data Warehouses

When you are scheduling a data loading process for Automated Data Distribution (ADD) v2 for data warehouses, you can optionally add the timezone parameter to the scheduled process (see Schedule a Data Load).

The timezone parameter identifies the time zone that ADD v2 will apply to the data records in the Output Stage that have a data type of either TIMETZ or TIMESTAMPTZ. Applying the time zone occurs during extracting data based on the data loading process being executed.

Depending on the cloud data warehouse you use, consider the following:

If the timezone parameter is not set, ADD v2 applies the default time zone, which is Europe/Prague.