Google Big Query

The Google Big Query Data Store is available for Reading and Writing data in 1Integrate.

Read and Write Support

Read	Write		FME Desktop Required
	Commit	Copy To

Data Support

Data	Support	Notes
Non-Spatial
2D
Measured
Heighted
3D		Note: Support for 3D is in BETA when using this Data Store. For more information about 3D data in 1Integrate, please refer to Full 3D Support.

Key Information

• This format is only available as an Extension.

Parameters

Read and Commit

Parameter	Description
Service Account Key (.json)	A .json file containing your credentials, generated from Google BigQuery.
Project	The project name in BigQuery.
Dataset	The dataset name, taken from BigQuery.
Include views	Select to include views from BigQuery.
Include external tables	Select to include external tables.

Copy To

Parameter	Description
Export Service Account Key (.json)	A .json file containing your credentials, generated from Google BigQuery.      Note: You must have "Create Jobs" permission in BigQuery to use the output feature.
Project	The project name in BigQuery.
Dataset	The dataset name, taken from BigQuery.
Include views	Select to include views from BigQuery.
Include external tables	Select to include external tables.