The Data Warehouse can be accessed through the Query option within the left menu. This will take you to Big Query where you can access the data tables. This option will only be available if you have the Data Warehouse enabled.
The following tables are available:
- IP Addresses
- Order score
- Payment methods
The underlying data is available in near real time.
When running queries in your data warehouse you should use the
PARTITIONTIME column to filter the date range of your data.
Choosing a smaller date range by using
PARTITIONTIME will mean your queries are faster and incur less cost.
SELECT customerId, name, email FROM customers WHERE PARTITIONTIME = '2023-01-05'
The very latest data isn’t always available when comparing the
PARTITIONTIME column to a date. If you want the very latest data you should also query the “null partition”.
SELECT customerId, name, email FROM customers WHERE (PARTITIONTIME = '2023-01-05' OR PARTITIONTIME IS NULL)
If you want to filter on a specific time range you will also need to add a condition using one of the columns containing a timestamp.
SELECT customerId, name, email FROM customers WHERE (PARTITIONTIME = '2023-01-05' OR PARTITIONTIME IS NULL) AND updatedAt >= '2023-01-05T10:30:00.000Z' AND updatedAt >= '2023-01-05T11:00:00.000Z' ORDER BY updatedAt