# Google BigQuery

**Step 1 -**
Sign up for GCP
---------------

Go to <https://console.cloud.google.com/> and sign in with a Google Account

## **Step 2:** Get Google Credits

You will be provided with $300 credit initially and can be extended by Google on a case to case basis

## **Step 3:** Create a BigQuery Project

Create a BigQuery project on Google Console and note the project-id. Click and expand 'Select a Project' and create a new dedicated project for Daton

![Create BigQuery Project](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LbJ1eMq5M51cIpU163R%2F-LtisDtze9LMp5PB0vog%2F-Ltit2oDmHEqsZWG7RCs%2FGCP.jpg?alt=media\&token=b096ea3a-d5d4-4291-b480-923347fd91a9)

**Step 4:**
Enable BigQuery APIs
--------------------

Enable BigQuery APIs for the project by selecting dashboard on APIs and Services menu &#x20;

![Google APIs and Services](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LbJ1eMq5M51cIpU163R%2F-LtisDtze9LMp5PB0vog%2F-Ltiu2dw3nslfNzX2Mbo%2FEnable%20APIS.jpg?alt=media\&token=02b2e734-27f4-4c7d-91b7-4eec3d63232f)

![Enable BigQuery API](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LbJ1eMq5M51cIpU163R%2F-LtisDtze9LMp5PB0vog%2F-LtiuCYNDdu40VUIS2D9%2FEnable%20BQ%20APis.jpg?alt=media\&token=0f0b13a0-d265-4239-be8e-c378e9b905b2)

**Note:** Daton will only need BigQuery service from the Google Cloud Platform. Other services such as Compute Engine are not required

## **Step 5: Give Daton Permissions**

Grant&#x20;
warehouse edit permissions to Daton service account from GCP ‘IAM’ tab.&#x20;

Grant **'BigQuery Job User'** and **'BigQuery Data Owner'** permissions to the '<daton-bigquery@daton-210514.iam.gserviceaccount.com>' service account &#x20;

{% hint style="info" %}
Permissions to be granted are -  **'BigQuery Job User'** and **'BigQuery Data Owner'**&#x20;
{% endhint %}

![Permissions for Daton](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LbJ1eMq5M51cIpU163R%2F-LtisDtze9LMp5PB0vog%2F-Ltiv1YJHLPp1wCMYU81%2FPermission1.jpg?alt=media\&token=94f6507f-243e-41c2-b0a4-b11f3e6e0a4e)

![Permissions for Daton Service Account](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LbJ1eMq5M51cIpU163R%2F-LtisDtze9LMp5PB0vog%2F-LtivAEAHGrvoZK2oAPS%2FPermissions2.jpg?alt=media\&token=552402da-2390-48b5-afdb-1ee9095ac4ff)

## **Step 6: Configure BigQuery in Daton**

Note the BigQuery project-id and provide the same while integrating BigQuery data warehouse on Daton