Describing TSV format data
The following table shows the properties you must provide in a data source description for each data field in a location
, event
, or properties
block with TSV format data.
Setting | Description |
---|---|
id | The name for the column in the SQL table Example: event_elevation The ID specified should contain only numbers, lowercase letters and underscores and should start with a lowercase letter. |
sourceFieldIndex | The column index for this field in the source data |
purpose | (Optional) This setting enables you to identify the following fields: - latitude - longitude - elevation - source_id See Special fields for more information. |
sqlType | The SQL data type for this field. For more information about the data types supported, see Types of data. Example: DOUBLE |
For example:
{
"id": "organization_id",
"sourceFieldIndex": 8,
"purpose": "SOURCE_ID",
"sqlType": "VARCHAR"
}
Data validation
For TSV format data, each row will be split according to its tabularFormatSeparator
. Fields that
reference a column index that does not exist will associate NULL
to that field’s value.
Empty values will be interpreted as NULL
(the validity of this is based on its field specification).