> ## Documentation Index
> Fetch the complete documentation index at: https://resources.begenuin.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Big Query

Big query offers access to structured **data storage**, **analytics** which is cost effective and widely used by multiple business. You can easily connect your BigQuery account to the **BCC (Brand Control Center)** and receive the [Zero party data](https://resources.begenuin.com/faqs/zero_party_data). Firstly follow the below steps to build the BigQuery connection with the Google Cloud account.

## Big Query

**Step 1**: Open your google cloud account, create a service account and click on **Edit** permission.

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/image%201.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=05fb92165d059b32ef8afddeac6aa1f5" data-path="visual-aids/developers/integrations/image 1.png" />

**Step 2**: Assign the role.

* **2.1**: Role = BigQuery Data Editor

<img height="200" src="https://mintcdn.com/begenuin-47/NJcu7CMWLTSuwTBr/visual-aids/developers/integrations/Image%202.png?fit=max&auto=format&n=NJcu7CMWLTSuwTBr&q=85&s=140fd34101f1d3be65427e4a8b9f4967" data-path="visual-aids/developers/integrations/Image 2.png" />

**Step 3**: Set the condition as shown in the image.

* **3.1**: Set **Condition 1** as **Service** > **is** > **bigquery.googleapis.com**

* **3.2**: Set **Condition 2** as **Name** > **Starts with** > `projects/<project_name>/<data_set_name>`

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%203.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=20dc018cccfd15470e87adc377e92e7a" data-path="visual-aids/developers/integrations/Image 3.png" />

Following are the steps to connect your **BigQuery** account with BCC (Brand Control Center).

## Step 1: Login to BCC

![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXd6gMmBKvilx9hFZLVF7ZtetERT8D9xqIzRV5mt4F-OOvKGutgCcuwuNUncrjEq53Zkz8MeXwlLS2FTYWc92DgGe8MDdmqsxboB37mnN-m-3WoREMP6iC5VY1m254YUOOgJLxQ_wA?key=NJAxIqXiZeNiZiAibwOlOvRw)

## Step 2: Navigate to **Settings** > **Data Sources** > **Big Query**

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%204.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=418b44ad8ece9f3801054d38869a8829" data-path="visual-aids/developers/integrations/Image 4.png" />

## Step 3: **Select Account type** (**User** or **Service**),

### For User

Insert the **Dataset ID** (`project_name.dataset_name`) and set the **frequency** (**Daily**, **Weekly**, **Monthly**) to send the Data. **Sign in with Google** to connect the BigQuery account.

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%205.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=c5fc31a8e34c8fd616bf6a02320881e7" data-path="visual-aids/developers/integrations/Image 5.png" />

### For Service

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%206.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=6182b7fb35f6417ea8a5d15d55ce34f7" data-path="visual-aids/developers/integrations/Image 6.png" />

**Note:** If you have selected the **Service** as an **Account Type** then you have to upload the [JSON authentication file](https://support.google.com/a/answer/7378726?hl=en#:~:text=the%20service%20account-,Click%20APIs%20&%20Services,Click%20Close) along with dataset name

After uploading all the details click on the **Connect** button to connect the **BigQuery** account.

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%207.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=425fb2dd04b1a88ea99b42d52c003b37" data-path="visual-aids/developers/integrations/Image 7.png" />

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%208.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=97deb1065616d1d0c805a9df9cb11b5f" data-path="visual-aids/developers/integrations/Image 8.png" />

## Connection

Once the connection is successfully built then a table named “**genuin\_data**” will be created under your dataset.

<img height="200" src="https://mintcdn.com/begenuin-47/gJFgFPPy8brNIN0X/visual-aids/developers/integrations/Image%209.png?fit=max&auto=format&n=gJFgFPPy8brNIN0X&q=85&s=e35bbe1fe96aeecc434c47ad24263e31" data-path="visual-aids/developers/integrations/Image 9.png" />

All of the data will be passed based on the below structure.

<img height="200" src="https://mintcdn.com/begenuin-47/NJcu7CMWLTSuwTBr/visual-aids/developers/integrations/Image%2010.png?fit=max&auto=format&n=NJcu7CMWLTSuwTBr&q=85&s=b3eee5a92d41eed729d234861c0fb0b8" data-path="visual-aids/developers/integrations/Image 10.png" />

## Disconnection

Once the **BigQuery** account is connected then you can also **Disconnect** it.

<img height="200" src="https://mintcdn.com/begenuin-47/NJcu7CMWLTSuwTBr/visual-aids/developers/integrations/Image%2011.png?fit=max&auto=format&n=NJcu7CMWLTSuwTBr&q=85&s=8348b0414e0191ffac77045047659151" data-path="visual-aids/developers/integrations/Image 11.png" />

Confirm the **Disconnection** request as shown in the below screenshot.

<img height="200" src="https://mintcdn.com/begenuin-47/NJcu7CMWLTSuwTBr/visual-aids/developers/integrations/Image%2012.png?fit=max&auto=format&n=NJcu7CMWLTSuwTBr&q=85&s=cea39dd57c97b275635d85e1a09955d1" data-path="visual-aids/developers/integrations/Image 12.png" />

Once the connection is successfully disconnected then a toast message will be visible.

<img height="200" src="https://mintcdn.com/begenuin-47/NJcu7CMWLTSuwTBr/visual-aids/developers/integrations/Image%2013.png?fit=max&auto=format&n=NJcu7CMWLTSuwTBr&q=85&s=2d0d08e324e68b8af3c2d08838c63ead" data-path="visual-aids/developers/integrations/Image 13.png" />

Now the data will not be sent further although the past data will remain the same.
