BigQuery

BigQuery is Google Cloud’s fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time.

What is required

You will require the following in order to create a connection to BigQuery:

1. A Google service account containing the data you wish to add to Publisher.
2. The Google service account key in JSON format.
3. The ID of the Google Cloud Platform project.
4. The ID of the Google Cloud Platform quota project.
5. The name of the BigQuery dataset that contains the data you wish to add.

You can read more about Google service account keys here.

How to connect BigQuery

Follow the steps for adding a Data Source to open the new data source dialog and choose BigQuery from the list of available connectors.

You will be presented with the screen to configure your BigQuery connector:

To configure the connector:

1. Navigate to Google Cloud Platform
2. Create new service account credential or navigate to the existing service account which has access to the data you wish to add.
3. Select KEYS tab.
4. Click on ADD KEY and select option Create new key.
5. Create new key of type JSON
6. Upload JSON Service Account Key by drag&drop or click upload icon and choose file from system.
7. Paste the ID of the Google Cloud Platform project.
8. Paste the ID of the Google Cloud Platform quota project, parameters will be validated when you click NEXT.
9. Select a dataset you wish to connect.