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:

• 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.

{
  "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"
	}
]