Google BigQuery Quick Facts

About Quick Facts Tables

Format Type Identifier

SAFE.GOOGLE-BIGQUERY.GOOGLEBIGQUERY

Reader/Writer

Writer

Dependencies

  • Google Cloud account
  • Python 3.6+

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