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

# Connecting to Google BigQuery

> Google BigQuery is a multi-cloud data warehouse that is used to store all data and analyze it. Google BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service that supports querying using ANSI SQL. It also has built-in machine learning capabilities.

The Service Account requires storage and BigQuery permissions. The bucket should provide storage permissions to the Service account, under the bucket’s permissions.

## There are three options to connect to Google BigQuery:

* Create a new project
* Edit an existing project connection
* Export data from the Export tab > Schedule run button

## Connecting to Google BigQuery when Creating a New Project

<Steps>
  <Step>
    Click Enrich. The Enrich page is displayed.
  </Step>

  <Step>
    Click 'Create project'. The Create a new project window is displayed.
  </Step>

  <Step>
    Type in a new project name. The project name needs to be unique.
  </Step>

  <Step>
    Select a use case from the drop-down.
  </Step>

  <Step>
    Click Create project. The Upload a dataset window appears.
  </Step>

  <Step>
    Select Google BigQuery.
  </Step>

  <Step>
    Choose a connection name.
  </Step>

  <Step>
    Type in the Bucket Name.
  </Step>

  <Step>
    Upload the service account key JSON.
  </Step>

  <Step>
    Click Upload. Your data is uploaded.
  </Step>

  <Step>
    Click Test Connection to make sure the connection is successful. A message is displayed informing you if the connection was successfully created or not. If the test connection failed, then you are unable to create a connection. Before creating a new connection, a Test Connection must be run. If the test failed, or a parameter was changed, the Create button will be disabled, and you need to create a new connection.
  </Step>

  <Step>
    After the test connection has succeeded, click Create in order to create the connection.
  </Step>
</Steps>