Google BigQuery Quick Facts
|
Format Type Identifier |
SAFE.GOOGLE-BIGQUERY.GOOGLEBIGQUERY |
|
Reader/Writer |
Writer |
|
Dependencies |
|
|
Dataset Type |
Google BigQuery Dataset Name |
|
Feature Type |
Google BigQuery Table Name |
|
Typical File Extensions |
Not applicable |
|
Automated Translation Support |
No |
|
User-Defined Attributes |
Yes |
|
Coordinate System Support |
LL84, LL-WGS84, EPSG:4326 |
|
Generic Color Support |
No |
|
Spatial Index |
No |
|
Schema Required |
Yes |
|
Transaction Support |
No |
|
Encoding Support |
UTF-8 |
|
Geometry Type |
gbq_type |
BigQuery FME Schema to BigQuery Mapping
| FME Type | Google BigQuery Type |
|---|---|
| fme_buffer, fme_xml, fme_json, fme_char, fme_varchar | STRING |
| fme_binarybuffer, fme_binary(width), fme_varbinary(width) | BYTES |
| fme_boolean | BOOLEAN |
| fme_date | DATE |
| fme_time | TIME |
| fme_datetime | DATETIME |
| fme_buffer | TIMESTAMP |
| fme_int8, fme_uint8, fme_int16, fme_uint16, fme_int32, fme_uint32, fme_uint64, fme_int64 | INTEGER |
| fme_decimal(width,decimal) | NUMERIC |
| fme_real32 | FLOAT |
| fme_real64 | FLOAT64 |
Google BigQuery Geometry Support
|
Geometry |
Supported? |
|
aggregate |
no |
|
circles |
no |
|
circular arc |
no |
|
donut polygon |
no |
|
elliptical arc |
no |
|
ellipses |
no |
|
line |
yes |
|
none |
yes |
|
point |
yes |
|
polygon |
yes |
|
raster |
no |
|
solid |
no |
|
surface |
no |
|
text |
no |
|
z values |
no |