Insights data export service data model dictionary
The Insights data export service data model dictionary provides an overview of each table available in the data export service, including the columns within each table, their data types, and nullability. This document is intended to help you determine which tables and columns to use and how to access the data when extracting information for custom reports, spreadsheets, or other external applications.
Data type definitions
NOTE The export output is Comma Separated Values (CSV), so all values, regardless of data type, are written as text in the exported file. Numbers appear as their textual numeric representation (for example, the number 42 is written as "42"), booleans appear as "true" or "false", and timestamps use the ISO-8601 date and time format with millisecond precision. The format follows YYYY-MM-DDTHH:MM:SS.sssZ, for example: 2025-11-22T22:55:02.027Z.
| Data type | Definition |
|---|---|
| STRING | A character string of text, used for identifiers, names, labels, or other alphanumeric data. |
| BOOLEAN | A logical value representing true or false. |
| INTEGER | A 32-bit signed integer. Used for whole number values without decimals. |
| BIG_INTEGER | A 64-bit signed integer. Used for very large whole number values. |
| FLOAT | A single-precision floating-point number. Used when decimals are required. |
| TIMESTAMP | A date and time value with time-zone reference. Used for event times. |
Glossary
The following glossary defines common terms and database concepts referenced throughout the data model dictionary.
| Term | Definition |
|---|---|
| Primary key (PK) | A column or combination of columns that uniquely identifies each row in a table. |
| Data type | Specifies the kind of data a column can hold (e.g., STRING, INTEGER, BOOLEAN). See the Data type definitions table for details. |
| Nullable | Indicates whether a column can contain NULL values. If a column is nullable, it may have missing or undefined data. |
| Bit value | A Boolean representation stored as 0 (FALSE) or 1 (TRUE). |
|
Entity Relationship Diagram (ERD) |
A visual representation of tables and their relationships within a dataset. |