# BigQuery

Follow these steps to create a dataset in Google Cloud Platform for Daasity to load data into. 

## 1. Create a new Project

<div data-full-width="false"><figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/M26rUzNmeTXg3SRSfft9/image.png" alt=""><figcaption></figcaption></figure></div>

## 2. Create API Services / Credentials

<div data-full-width="false"><figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/u74qZMSvGdSJK967lHek/image.png" alt=""><figcaption></figcaption></figure></div>

## 3. Create new service account

<div data-full-width="false"><figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/reuALgJ3sPD1wfHPFJXh/image.png" alt=""><figcaption></figcaption></figure></div>

<div data-full-width="false"><figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/V5AbsVlkakG1GbALiHSw/image.png" alt=""><figcaption></figcaption></figure></div>

## 4. Create appropriate Service Roles

Service account **must** have **BigQuery Admin** and **Storage Admin** roles. They are necessary to grant privileges for service accounts when createing schemas/tables and loading data into them.

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/Qqnvl4iK6k3E9bm2ec5E/image.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/n6W29BZahBJpycjo5hUq/image.png" alt=""><figcaption></figcaption></figure>

## 5. Download private key JSON

This file holds the credentials for the service account you created and will be used when setting up a BigQuery warehouse on the Daasity app.

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/Y5CnFS53cnaJKzho8awA/image.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/EapoCz7UAXIaVflKfUS9/image.png" alt=""><figcaption></figcaption></figure>