Source table column data types
Source tables support different data types for their columns, such as TEXT, LONG, or DOUBLE. Each of these types has different constraints that define the format of allowed values. Uploading any data that violates these constraints either leads to the value being corrected automatically or more often to the whole record being rejected while the data is being persisted. Records without any constraint violations are parsed and persisted normally, even if there are other records that do violate some constraints.
The following table lists all data types, their constraints, and if a violation leads to the encompassing record being rejected.
Data type | Description | Invalid records are rejected |
|---|---|---|
DOUBLE | Values must be valid floating-point numbers (corresponding to the 64-bit binary64 floating-point format as specified in the IEEE 754 Standard). If uploaded as part of a CSV file, all values that contain a grouping character, decimal separator, or both must correspond to the respective configurations made on the Configure columns page of the Add data table wizard. | Yes |
LONG | Values must be valid integer numbers from -9223372036854775808 to (and including) 9223372036854775807. If uploaded as part of a CSV file, all values that contain a grouping character must correspond to the respective configurations made on the Configure columns page of the Add data table wizard | Yes |
TEXT | Values must be valid strings of characters (corresponding to the Unicode Standard). Very long values will be truncated automatically after 8000 characters. | No |
DATE | Values must follow common date and time conventions (for example, the ISO 8601 Standard for text-based values). The values are persisted with millisecond precision as the number of milliseconds that have passed since the Unix epoch (1970-01-01 00:00:00.000) and interpreted as having time zone UTC±00:00. Dates and times from the past are rejected if before 1900-01-01 00:00:00.000. If uploaded as part of a CSV file, all values must be text-based and match the Date/Time formatting pattern given for the respective Date column on the Configure columns page of the Add data table wizard. Values that contain time zone information are converted to time zone UTC±00:00 while being persisted. | Yes |