[Ultimate]{class="badge positive"}

Create a Google Big Query source connection in the UI

The Google BigQuery source is available in the sources catalog to users who have purchased Real-Time Customer Data Platform Ultimate.

Source connectors in Adobe Experience Platform provide the ability to ingest externally sourced data on a scheduled basis. This tutorial provides steps for creating a Google Big Query source connection using the Platform user interface.

Getting started

This tutorial requires a working understanding of the following components of Experience Platform:

If you already have a valid Google BigQuery connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.

Gather required credentials

In order to access your Google BigQuery account on Platform, you must provide the following OAuth 2.0 authentication values:

The project ID of the default Google BigQuery project to query against.
The ID value used to generate the refresh token.
The secret value used to generate the refresh token.
The refresh token obtained from Google used to authorize access to Google BigQuery.

For more information about these values, refer to this Google BigQuery document.

Connect your Google BigQuery account

In the Platform UI, select Sources from the left navigation to access the Sources workspace. The Catalog screen displays a variety of sources that you can create an account with.

You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search bar.

Under the Databases category, select Google BigQuery and then select Add data.

The Connect to Google Big Query page appears. On this page, you can either use new credentials or existing credentials.

Existing account

To connect an existing account, select the Google BigQuery account you want to connect with, then select Next to proceed.

New account

If you are using new credentials, select New account. On the input form that appears, provide a name, an optional description, and your Google BigQuery credentials. When finished, select Connect to source and then allow some time for the new connection to establish.

Next steps

By following this tutorial, you have established a connection to your Google BigQuery account. You can now continue on to the next tutorial and configure a dataflow to bring data into Platform.