Google Big Query is a great tool to use to store and analyze your video player data. Before you can send data to Big Query, you'll need to configure a Connector. 

Datazoom → Google BigQuery

As with some Connectors, there are certain pieces of information that you'll need before you proceed. Here are the things you'll need before you attempt to configure a Connector to Google BigQuery:

Please make sure you have a table configured with field names before you begin to setup the Connector. Feel free to copy our default table schema.

Please make sure that you have an appropriate Role attached to the service account that allows read/write access to BigQuery.

• Project ID

• Data Set

• Table Name

• Service Account JSON

• Customer Map
  

  

Customer Map Format Example:

The key names on the left of the configuration represent data points selected in your Data Pipe configuration as outlined in our How to Configure a Data Pipe document. Feel free to copy our default mapping which contains all of our data points.

If you’re collecting custom metadata be sure to prepend custom. to your key name. (see example below)

{
  "bq_table_mapping": {
    "type": "BQ_event_type",
    "timestamp": "BQ_timestamp",
    "app_session_id": "BQ_app_session_id",
    "content_session_id": "BQ_content_session_id",
    "custom.my_key_name": "BQ_my_key_name"
   }
}

Customer Table Format Example:
The example below illustrates a sample table schema for BigQuery. The name represents the right hand side name from the mapping above. Once again, feel free to copy our default table schema which contains all of our data points.

[
	{
		"mode": "NULLABLE",
		"name": "BQ_event_type",
		"type": "STRING"
	},
	{
		"mode": "NULLABLE",
		"name": "BQ_timestamp",
		"type": "timestamp"
	},
	{
		"mode": "NULLABLE",
		"name": "BQ_app_session_id",
		"type": "STRING"
	},
	{
		"mode": "NULLABLE",
		"name": "BQ_content_session_id",
		"type": "STRING"
	},
	{
		"mode": "NULLABLE",
		"name": "BQ_my_key_name",
		"type": "STRING"
	}
]