1. Table exports
Table exports write each of the 40 tables as Apache Parquet files, compressed with Zstandard, once per day.- Schedule: each export covers one day in the project’s time zone and is written after 01:00 local time on the following day.
- Completeness: an export appears in the list only after all its files are written. Large tables are split into several files.
- File metadata: every file comes with its size, checksum and creation time. If an export is regenerated, file names stay the same and the creation time changes, so use the creation time to detect a reload.
- Retention: completed exports stay available for 365 days. One list request covers up to 92 days.
- Activation: table exports are enabled per project. Contact us to enable them.
List and download with the CLI
--dir keeps the <table>/<file>.parquet layout, which makes loading per table straightforward.
List and download with the API
GET /observe/tableExports/{filename}/downloadLink, URL-encoding the slashes in the file name. Links are short-lived, so request each link directly before downloading the file.
Both paths need a key with the table exports read permission.
2. Time-series exports
Time-series exports write the pre-calculated KPI series of the console as files. Start them in the console under Observe → Settings → Exports or withPOST /observe/timeSeries/export.
- Formats: CSV or Apache Parquet, one file per series, up to 20 series per request.
- Dimensions: exclude dimensions you do not need. Their values are summed, so totals stay correct.
- Ranges: hourly data for up to 92 days, daily data for up to 731 days and monthly data without a limit.
- Processing: the API generates files while streaming newline-delimited JSON progress over the open HTTP request. Keep the connection open until a
completedorfailedevent arrives. Disconnecting can cancel generation. A project can run two exports at the same time. - Availability: files can be downloaded for 7 days through short-lived links.
GET /observe/timeSeries/exports and check one with GET /observe/timeSeries/exports/{exportID}. After completion, request a link for each file with GET /observe/timeSeries/exports/{exportID}/files/{fileName}/downloadLink. After an interrupted request, check the export status before starting another export.
3. Per-user export and deletion
To answer a data subject request, export or delete the Observe data of individual users by the user ID your integration sends.
Deletion covers the data stored by Observe. Copies you have already loaded into your own platform need their own deletion step.
Connect your data platform
Load exports into your warehouse or lakehouse.
Data model
Tables, keys and time columns.