Google Big Query

The Google Big Query datastore 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 3D Support.

Input and Output Parameters

Input parameters

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.

Output parameters

Parameter	Description
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.