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.  

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