BigQuery Data Types
The Google BigQuery (Legacy) destination maps fields from records to BigQuery columns in existing tables based on matching names and compatible data types. If needed, the destination converts Data Collector data types to BigQuery data types.
The following table lists the Data Collector data types and the BigQuery data types that the destination converts them to:
| Data Collector Data Type | BigQuery Data Type |
|---|---|
| Boolean | Boolean |
| Byte Array | Bytes |
| Date | Date |
| Datetime | Datetime or Timestamp |
| Decimal | Decimal |
| Double | Float |
| Float | Float |
| Integer | Integer |
| List | Array |
| List-Map | Record with repeated fields |
| Long | Integer |
| Map | Record |
| Short | Integer |
| String | String |
| Time | Time |
The Google BigQuery (Legacy) destination cannot convert the following Data Collector
data types:
- Byte
- Character