Google BigQuery

This destination is currently under final review and will be available soon.

BigQuery is Google's data warehouse that enables scalable analysis over data. This integration allows pushing your specific input properties, or all of them, to BigQuery.

Key features

The Google BigQuery destination provides the following key features:

• Events structure: our Events reference feeds BigQuery, meaning that your data is properly bridged to the expected fields in an optimized way.

• Universal schema: store events data without adjusting BigQuery's schema.

• Data control: input your properties or just check a box to send them all to BigQuery.

Destination setup

Ensure BigQuery API is enabled. More details are available following this LINK. Use Destination filters to refine events and/or other properties matching your specific needs.

First, you need to create a BigQuery table, with a specific universal schema, for storing raw data into it. See the following two subsections for a complete walkthrough.

Dataset

Access BigQuery console to locate your (1) project identifier and click (2) the three dots on the right. Select (3) Create dataset from the menu or, alternatively, you can use an existing dataset and jump to the next subsection.

Dataset creation #1.

Input a (4) dataset identifier (E.g. "myDatasetId"), select a (5) location type and click (6) CREATE DATASET.

Dataset creation #2.

Table

Create a table with the following structure:

Field name	Type	Mode
rawDataCa	String	Required
createdAt	Timestamp	Required

The esiest way to create it is to click (7) the plus button:

Compose a new query.

copy and paste the following query in (8) the input area:

CREATE TABLE IF NOT EXISTS [PROJECT_ID].[DATASET_ID].[TABLE_ID] (rawDataCa STRING NOT NULL, createdAt TIMESTAMP NOT NULL) OPTIONS(description="CA raw event data stored in Google BigQuery")

Replace [PROJECT_ID] , [DATASET_ID] and [TABLE_ID] with your project, dataset and table identifier respectively. You set your table identifier at this step.

and then click the (9) RUN button.

Run table creation query.

Configuration

Settings	Description
Authentication	Required Your credentials with Google as set in the Commanders Act interface following: Administration ➜ Connector Credentials ➜ Add connector credentials ➜ BigQuery
Project Id	Required Select your project identifier from the dropdown menu as reported in BigQuery console. More details are available following this LINK.
Dataset Id	Required Select your dataset identifier as reported in BigQuery console. More details are available following this LINK.
Table Id	Required Select table identifier as reported in BigQuery console. More details are available following this LINK.
Send all properties to BigQuery	Flag this option to send all properties to BigQuery.
Properties to include	When Send all properties to BigQuery is not checked, you can input the property names to be sent to BigQuery.

Quick reference

Commanders Act Events	BigQuery Table Columns
[Any events] [1]	rawDataCa, createdAt [2]

[1] Use Destination filters to specify your matching events. [2] Two columns: rawDataCa contains your event properties, while createdAt is the creation timestamp.