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 bits 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:

When setting up your Customer Map, refer to the Supported Data Points for your specific Collector.  You don't need to set Event Type data points as they are all Collected via the necessary "event_type" configuration item.

Note: You must include the "event_type" data point in your Customer Map Configuration. We suggest you include "event_timestamp" and "playheadPosition" for completeness.

This is the format to use when creating a Customer Map. The names on the left of the configuration map to the data points selected in your Data Pipe configuration as outlined in our How to Configure a Data Pipe document.

{
  "bq_table_mapping": {
    "event_type": "[BIGQUERY_FIELD_NAME]",
    "event_timestamp": "[BIGQUERY_FIELD_NAME]",
    "playheadPosition": "[BIGQUERY_FIELD_NAME]",
    "session_id": "[BIGQUERY_FIELD_NAME]",
    "sessionViewId": "[BIGQUERY_FIELD_NAME]",
    "bitrate": "[BIGQUERY_FIELD_NAME]",
    "playerState": "[BIGQUERY_FIELD_NAME]"
   }
}