What is the time zone used for timestamps in the Data Warehouse Connector?

Cloud

In the Matomo Data Warehouse Connector, all timestamps shown in the Export Jobs list are displayed in UTC. This includes the From Date, To Date, and Next Scheduled fields. Currently, the time zone used in this view cannot be changed.

list of export jobs in data warehouse connector

How ‘From Date’ and ‘To Date’ are determined

Data Warehouse exports run in scheduled 6-hour time windows. For the first automatic export of the day, the export starts slightly before the beginning of the day. A small buffer is added to ensure that late-arriving visits are not missed. The export then runs through the end of the first 6-hour window, which is approximately 00:00 to 06:00 UTC, with a small adjustment for the buffer.

Each subsequent export continues from where the previous export finished and processes the next 6-hour block of data.

What ‘Next Scheduled’ shows

The Next Scheduled value shows the start time of the next automatic export window.

All timestamps are standardised to UTC to ensure consistency across exports and integrations with external data warehouse platforms.

Previous FAQ: How long is exported Matomo data available in Amazon S3?