# 12.3 Connect GCP & BigQuery to Adobe Experience Platform

## Objectives

* Explore the API & Services within Google Cloud Platform
* Be familiar with OAuth Playground for testing Google APIs
* Create your first BigQuery connection in Adobe Experience Platform

## Context

Adobe Experience Platform provides a connector within **Sources** that will help you bring BigQuery datasets into Adobe Experience Platform. This data connector is based on the Google BigQuery API. Therefore, it's important to properly prepare your Google Cloud Platform and your BigQuery environment to receive API calls from Adobe Experience Platform.

To configure the BigQuery Source Connector in Adobe Experience Platform, you'll need these 4 values:

* project
* clientId
* clientSecret
* refreshToken

So far you only have the first one, the **Project ID**. This **Project ID** value is a random ID that was generated by Google when you created your BigQuery project during exercise 12.1.

Please copy project id in a separated text file.

| Credential | Naming | Example              |
| ---------- | ------ | -------------------- |
| Project ID | random | composed-task-306413 |

You can check your Project ID any time by clicking on your **Project Name** in the top menu bar:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-5aaf51ed7056054b4f0e9a3f920a647290fe2229%2FprojectMenu.png?alt=media)

You'll see you Project ID on the right side:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-029b570257cda90777701c61e15fe5db6bff4c58%2Fprojetcselection.png?alt=media)

In this exercise you'll learn how to get the other 3 required fields:

* clientId
* clientSecret
* refreshToken

## 12.3.1 Google Cloud API & Services

To start, please go back to the Google Cloud Platform home page. To do this, simply click on the logo in the top left-corner of your screen.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-c44c90bb04caacc15d56bc345b43537d1bd1646b%2F5.png?alt=media)

Once you are on the home page, go to left menu and click **APIs & Services**, then Click on **Dashboard**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-f94bb60bf3b9c974e03da3654ede51d7b99d850c%2F4.png?alt=media)

You'll now see the **APIs & Services** homepage.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-8ecd51413f52b76937494b197dc43701357ae927%2F6.png?alt=media)

On this page, you're able to see the usage of your various Google API connections. In order to setup an API Connection so that Adobe Experience Platform can read from BigQuery, you need to follow these steps:

* First, you need to create an OAuth consent screen to enable future authentications. Google's security reasons also require a human being to make the first authentication, before a programmatic access is allowed.
* Second, you need API Credentials (clientId and clientSecret) that will be used for API authentication and access to your BigQuery Connector.

## 12.3.2 OAuth Consent Screen

Let's start with creating the OAuth Consent Screen. In the left menu on the **APIs & Services** homepage, click **OAuth consent screen**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-0a635a907df46b64feff3a4e94187222a1f69193%2F6-1a.png?alt=media)

You'll then see this:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-4c934cbc1dcd45df775e0994d99a671cf6781d4a%2F6-1.png?alt=media)

Select the User Type: **External**. Next, click **CREATE**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-1efa36f369f834751a4b3aaf800acfa24717dc3f%2F6-2.png?alt=media)

You'll then be on the **OAuth Consent Screen configuration** window.

The only thing to do here is to enter the name of the consent screen in the **Application name** field and select the **User support email**. For the Application name, use this naming convention:

| Naming                                         | Example                           |
| ---------------------------------------------- | --------------------------------- |
| `--demoProfileLdap-- - AEP BigQuery Connector` | vangeluw - AEP BigQuery Connector |

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-54a92527c10900277b5f018a896bffc97698186d%2F6-3.png?alt=media)

Next, scroll down until you see **Developer contact information** and fill out an email address.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-cdea92b9c71490d80cc6853a22e685582b4231ba%2F6-3a.png?alt=media)

Click **SAVE AND CONTINUE**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-33ab02f815fda7f8c416dfeeb11aadbac68f17c0%2F6-4.png?alt=media)

You'll then see this. Click **SAVE AND CONTINUE**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-43c27f4fcfb0b12b9659bc07b18001d0c3707ff7%2Fo1.png?alt=media)

You'll then see this. Click **SAVE AND CONTINUE**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-a9c30645b77b86b46437debe5c7dc0adba4ffae1%2Fo2.png?alt=media)

You'll then see this. Click **BACK TO DASHBOARD**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-b8d7ad8e7bd0ab03b48f4dfffc239a4f5ec853c0%2Fo3.png?alt=media)

You'll then see this. Click **PUBLISH APP**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-d9ff6f4d77c00c42d59d4aaae040090be99ad601%2Fo4.png?alt=media)

Click **CONFIRM**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-add85f7ca44630fb04231e794756bd69a570215d%2Fo5.png?alt=media)

You'll then see this.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-d5813034ded7798c394401b8295e4d760b3a70fe%2Fo6.png?alt=media)

In the next step step, you'll finish the API setup and get your API credentials.

## 12.3.3 Google API Credentials: Client Secret and Client Id

In the left menu, click **Credentials**. You'll then see this:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-db03086cec16dbb94591a654c7401c564b7bd38a%2F7.png?alt=media)

Click the **+ CREATE CREDENTIALS** button.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-d139756777fc097ab30b529d24b58045970813a4%2F9.png?alt=media)

You'll see 3 options. Click the **OAuth client ID**:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-a9bdfe2b4adbefcf9cf6113313bc2f595dd763c4%2F11.png?alt=media)

In the next screen, select **Web application**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-a50170861b95535346ec1abea9a7540cbd820f04%2F12.png?alt=media)

Several new fields will pop up. You now need to enter the **Name** of the OAuth Client ID and also enter the **Authorised redirect URIs**.

Follow this naming convention:

| Field                    | Value                                           | Example                                         |
| ------------------------ | ----------------------------------------------- | ----------------------------------------------- |
| Name                     | ldap - AEP BigQuery Connector                   | vangeluw - Platform BigQuery Connector          |
| Authorised redirect URIs | <https://developers.google.com/oauthplayground> | <https://developers.google.com/oauthplayground> |

The **Authorised redirect URIs** field is a very important field because you'll need it later to get the RefreshToken you need to finish the setup of the BigQuery Source Connector in Adobe Experience Platform.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-326fde89e6e301b84126342d5b83e4bcff28473c%2F12-1.png?alt=media)

Before you continue, you need to physically push the **Enter** button after entering the URL to store the value in the **Authorised redirect URIs** field. If you don't click the **Enter** button, you'll run into issues at a later stage, in the **OAuth 2.0 Playground**.

Next, click **Create**:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-8de988732826b39ef62ceea749afdbe9a2168d51%2F19.png?alt=media)

You'll now see now your Client ID and your Client Secret.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-7b477322a8ae215891aaaf6e390e2d490934b72c%2F20.png?alt=media)

Please copy these two fields and paste them in a text file on your desktop. You can always access these credentials at a later stage, but it's easier if you save them in a text file next to your BigQuery Project ID.

As recap for your BigQuery Source Connector setup in Adobe Experience Platform, you now have these values already available:

| BigQuery Connector Credentials | Value                                           |
| ------------------------------ | ----------------------------------------------- |
| Project ID                     | your own Project ID (ex.: composed-task-306413) |
| clientid                       | yourclientid                                    |
| cilentsecret                   | yourclientsecret                                |

You're still missing the **refreshToken**. The refreshToken is a requirement because of security reasons. In the world of APIs, tokens typically expire every 24 hours. So the **refreshToken** is needed to refresh the security token every 24 hours, so that your Source Connector setup can keep connecting to Google Cloud Platform and BigQuery.

## 12.3.4 BigQuery API and the refreshToken

There are many ways to get a refreshToken to access Google Cloud Platform APIs. One of these options is for instance using Postman. However, Google has built something easier to test and play with their APIs, a tool called **OAuth 2.0 Playground**.

To access **OAuth 2.0 Playground**, go to <https://developers.google.com/oauthplayground>.

You'll then see the **OAuth 2.0 Playground** homepage.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-afa328cbdb9b4d9237f5e83cddd78ff9e5470fa3%2F22.png?alt=media)

Click on the **gear** icon in the top right side of your screen:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-b727c613331f69b2b6aa2e16bd3c83d68ee9f088%2F22-1.png?alt=media)

Make sure your settings are the same as what you can see in the image above.

Double check the settings to be 100% sure.

Once you are done, check the box of **Use your own OAuth credentials**

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-2570635ed9d2619390e9891e9caaf5dc0fcc997e%2F22-2.png?alt=media)

Two fields should appear, and you have the value for them.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-6ea8aee262e9ca3ee436fcb7fbc1b5c905ebf654%2F23.png?alt=media)

Please fill the fields following this table:

| Playground API settings | Your Google API credentials                               |
| ----------------------- | --------------------------------------------------------- |
| OAuth Client ID         | your own Client ID (in the text file on your desktop)     |
| OAuth Client Secret     | your own Client Secret (in the text file on your desktop) |

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-40de42c12ce40e954c7f85aac8c4ac8e4391a92a%2F23-a.png?alt=media)

Copy the **Client ID** and **Client Secret** from the text file you created on your desktop.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-7b477322a8ae215891aaaf6e390e2d490934b72c%2F20.png?alt=media)

Once you've fill out your credentials, please click **Close**

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-b286dd6a2be3d25f62e8dcf6e5125d9718b0f50f%2F23-1.png?alt=media)

In the left menu, you can see all available Google APIs. Search for **BigQuery API v2**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-0f8046cbfda67ccca3553fc4ee67a8b67311a33a%2F27.png?alt=media)

Next, select the scope as indicated in the below image:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-e70e919a7cd5f62ba30fc8549dec6d9550ca166c%2F26.png?alt=media)

Once you have selected them, you should see a blue button which says **Authorize APIs**. Click on it.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-9ab1ec361f184dbe0b7dbe9dfb7f192485ee7ad7%2F28.png?alt=media)

Select the Google Account you used for setting up GCP and BigQuery.

You might see a big warning: **This app isn't verified**. This is happening because your Platform BigQuery Connector hasn't been formally reviewed yet, so Google doesn't know if it's an authentic app or not. You should disregard this notification.

Click **Advanced**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-5c3ca89dd3c05128a01fe9d50684f52527260e01%2F32.png?alt=media)

Next, click on **Go to ldap - AEP BigQuery Connector (unsafe)**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-f8402812aacdc413b2ed3ee7896e151ffe93acc8%2F33.png?alt=media)

You'll be redirected to our OAuth Consent Screen that you created.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-10378a6f580444c2f91490cd3e5d28d97dd667ca%2F29.png?alt=media)

If you use Two-Factor Authentication (2FA), enter the verification code sent to you.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-a01320b01261d839c9b3ad8feff26aa6f9fe4628%2F30.png?alt=media)

Google will now show you eight different **Permission** prompts. Click **Allow** for all eight permission-requests. (This is a procedure that has to be followed and confirmed once by a real human being, before the API will allow programmatic requests)

Again, **eight different popup-windows** will not be shown, you have to click **Allow** for all of them.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-10378a6f580444c2f91490cd3e5d28d97dd667ca%2F29.png?alt=media)

After the eight permission requests, you'll see this overview. Click **Allow** to finish the process.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-794ed62edcead206f63e3186442e18c1d46917ee%2F35.png?alt=media)

After the last **Allow**-click, you'll be sent back to the OAuth 2.0 Playground and you'll see this:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-823f95f881829a1826b5e4fe98b9a050a7084c51%2F36.png?alt=media)

Click **Exchange authorization code for tokens**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-0c14eefbec13bd898a03b12730c80c6f1d7fc2c9%2F36-1.png?alt=media)

After a couple of seconds, the **Step 2 - Exchange authorization code for tokens** view will automatically close, and you'll see **Step 3 - Configure request to API**.

You have to go back to **Step 2 Exchange authorization code for tokens**, so click on **Step 2 Exchange authorization code for tokens** again to visualize the **Refresh token**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-970ab002b888bb9322756fcffedf382ef002880a%2F37.png?alt=media)

You'll now see the **Refresh token**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-530a6ee70a86fefd9ba669c6ac35ff915071d88a%2F38.png?alt=media)

Copy the **Refresh token** and paste it in the text file on your desktop along with the other BigQuery Source Connector Credentials:

| BigQuery Source Connector Credentials | Value                                               |
| ------------------------------------- | --------------------------------------------------- |
| Project ID                            | your own random Project ID (ex.: apt-summer-273608) |
| clientid                              | yourclientid                                        |
| cilentsecret                          | yourclientsecret                                    |
| refreshtoken                          | yourrefreshtoken                                    |

Next, let's setup your Source Connector in Adobe Experience Platform.

## Exercise 12.3.5 - Connect Platform with your own BigQuery table

Log in to Adobe Experience Platform by going to this URL: <https://experience.adobe.com/platform>.

After logging in, you'll land on the homepage of Adobe Experience Platform.

![Data Ingestion](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-d3766e8abcdcae565589d172ff39148a026b3712%2Fhome.png?alt=media)

Before you continue, you need to select a **sandbox**. The sandbox to select is named `--aepSandboxId--`. You can do this by clicking the text **\[!UICONTROL Production Prod]** in the blue line on top of your screen. After selecting the appropriate sandbox, you'll see the screen change and now you're in your dedicated sandbox.

![Data Ingestion](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-f8fe0607dc3e272ebd2416a98220bb1d82c1a166%2Fsb1.png?alt=media)

In the left menu, go to Sources. You'll then see the **Sources** homepage. In the **Sources** menu, click on **Databases**. Click the **Google BigQuery** card. Next, click **Set up** or **+ Configure**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-961a14eb32fa2f2c49779c0ea92c29e77f339ea6%2F1.png?alt=media)

You should now create a new connection.

Click on **New account**. You now need to fill out all the below fields, based on the setup you did in GCP and BigQuery.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-5d5bb42833a23c698b91579c3a9d7f929c4d4e6e%2F3.png?alt=media)

Let's start by naming the connection:

Please use this naming convention:

| BigQuery Connector Credentials | Value                                       | Example                        |
| ------------------------------ | ------------------------------------------- | ------------------------------ |
| Account Name                   | `--demoProfileLdap-- - BigQuery Connection` | vangeluw - BigQuery Connection |
| Description                    | `--demoProfileLdap-- - BigQuery Connection` | vangeluw - BigQuery Connection |

Which should give you something like this:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-aad0a19eb498258a3998b144f9ba24b62de53bbd%2F39-a.png?alt=media)

Next, fill out the GCP and BigQuery API **Account Authentication**-details that you stored in a text-file on your desktop:

| BigQuery Connector Credentials | Value                                               |
| ------------------------------ | --------------------------------------------------- |
| Project ID                     | your own random Project ID (ex.: apt-summer-273608) |
| clientId                       | ...                                                 |
| cilentSecret                   | ...                                                 |
| refreshToken                   | ...                                                 |

Your **Account Authentication**-details should now look like this:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-77ca6433931d1a983a566fb8fbc9021c0b85e783%2F39-xx.png?alt=media)

After filling out all these fields, click **Connect to source**.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-d29edcf9ed6dedc7381a8f0fcf91f4888ff2079a%2F39-2.png?alt=media)

If your **Account Authentication** details were correctly filled out, you should now see a visual confirmation that the connection is working properly, by seeing the **Connected** confirmation.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-b6cac0895c9283c6d411608fb93583de7f8ba529%2Fprojectid.png?alt=media)

Now that your connection is created, please click **Next**:

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-c4f6158393a89add2751c6a10f7386989b7c6a07%2F42.png?alt=media)

You will now see the BigQuery dataset you created during exercise 12.2.

![demo](https://858372621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpBC8bA57il8Sj47B7QPJ%2Fuploads%2Fgit-blob-73535c6d6aba6013a495e7d13e164e3a02163977%2Fdatasets.png?alt=media)

Well done! In the next exercise, you'll load data from that table and map it against a schema and dataset in Adobe Experience Platform.