ServiceNow to Google BigQuery mapping

AutoSync maps ServiceNow object types to the following Google BigQeury column types:


ServiceNow object type	Google BigQuery column type
`audio`	`STRING`
`basic image`	`STRING`
`choice`	`STRING`
`collection`	`JSON`
`color`	`STRING`
`condition string`	`STRING`
`conditions`	`STRING`
`currency`	`NUMERIC`
`data structure`	`STRING`
`date`	`DATE`
`date/time`	`DATETIME`
`decimal`	`NUMERIC`
`document id`	`STRING`
`domain id`	`JSON`
`domain path`	`STRING`
`due date`	`STRING`
`duration`	`NUMERIC`
`encrypted text`	`STRING`
`field name`	`STRING`
`file attachment`	`STRING`
`floating point number`	`FLOAT64`
`fx currency`	`NUMERIC`
`html`	`STRING`
`icon`	`STRING`
`image`	`STRING`
`integer`	`INT64`
`ip address`	`STRING`
`journal`	`STRING`
`journal input`	`STRING`
`journal list`	`STRING`
`list`	`STRING`
`long`	`INT64`
`name-value pairs`	`STRING`
`password (1 way encrypted)`	`STRING`
`password (2 way encrypted)`	`STRING`
`percent complete`	`NUMERIC`
`phone number (e164)`	`STRING`
`price`	`NUMERIC`
`reference`	`JSON`
`script`	`STRING`
`script (plain)`	`STRING`
`slush bucket`	`STRING`
`string`	`STRING`
`string (full utf-8)`	`STRING`
`suggestion`	`STRING`
`sys id (guid)`	`STRING`
`table name`	`STRING`
`template value`	`STRING`
`time`	`TIME`
`translated html`	`STRING`
`translated text`	`STRING`
`true/false`	`BOOL`
`user roles`	`STRING`
`url`	`STRING`
`video`	`STRING`
`wiki`	`STRING`
`workflow`	`STRING`