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. Please make sure you have a table configured with field names before you begin to setup the Connector.
Here are the things you'll need before you attempt to configure a Connector to Google BigQuery:
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]" } }
You will need to ensure that you have a Billing Account that is attached to the project you are using.
You will need to ensure that you have a Role attached to the service account that allows read/write access to BigQuery
Comments
0 comments
Article is closed for comments.