---
title: Connecting BigQuery to Mozart Data
description: Welcome to Mozart Data! This guide will explain how to connect your BigQuery data warehouse to Mozart Data.
---

[Skip to content](https://help.mozartdata.com/docs/bigquery-mozart-data#main-content)

English

Show submenu for translations

![Mozart Data Logo - Purple (2).png\]](https://help.mozartdata.com/hs-fs/hubfs/Mozart%20Data%20Logo%20-%20Purple%20(2).png?height=30&name=Mozart%20Data%20Logo%20-%20Purple%20(2).png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to mozartdata.com](https://mozartdata.com/)

[Go to mozartdata.com](https://mozartdata.com/)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.mozartdata.com/docs?hsLang=en)
2. [Getting Started](https://help.mozartdata.com/docs/getting-started?hsLang=en)

# Connecting BigQuery to Mozart Data

## Welcome to Mozart Data! This guide will explain how to connect your BigQuery data warehouse to Mozart Data.

### **Before You Begin...**

**To connect BigQuery to Mozart Data, you will need the following:**

Roles

- [Create Service Accounts](https://cloud.google.com/iam/docs/understanding-roles#iam.serviceAccountCreator)(`roles/iam.serviceAccountCreator`) role
- [Project IAM Admin](https://cloud.google.com/iam/docs/understanding-roles#resourcemanager.projectIamAdmin) (`roles/resourcemanager.projectIamAdmin`) role

 To learn more about granting and revoking roles, please refer to this [link](https://cloud.google.com/iam/docs/granting-changing-revoking-access).

Enabled APIs & services

- Please make sure you have enabled the [BigQuery](https://console.cloud.google.com/apis/api/bigquery.googleapis.com/overview) and [Cloud Resource Manager](https://console.developers.google.com/apis/api/cloudresourcemanager.googleapis.com/overview) APIs

### Instructions

1\. Go to [https://console.cloud.google.com/](https://console.cloud.google.com/)

2\. Click the dropdown menu to view a list of Projects or create a new Project.

3\. Choose the BigQuery Project or Resource you wish to connect to Mozart Data.

4\. Copy the desired **BigQuery Project ID** and paste it into *Step 1* of the BigQuery setup form within Mozart.

![](https://help.mozartdata.com/hs-fs/hubfs/bq_1-gif.gif?width=524&height=299&name=bq_1-gif.gif)

5\. Open the navigation menu on the left and select **Service Accounts** to proceed.

![](https://help.mozartdata.com/hs-fs/hubfs/bq_2-gif.gif?width=527&height=301&name=bq_2-gif.gif)

6\. Click on '**Create Service Account**' if you do not already have an existing Service Account.

![](https://help.mozartdata.com/hs-fs/hubfs/image-png-Apr-03-2024-10-10-15-0844-PM.png?width=640&height=396&name=image-png-Apr-03-2024-10-10-15-0844-PM.png)

7\. Fill out the name for the **Service Account**, and a **Service Account ID** will be auto-generated. Then, grant the following permissions to the Service Account:

- BigQuery User
- BigQuery Metadata Viewer
- BigQuery Data Editor
- BigQuery Resource Viewer

![](https://help.mozartdata.com/hs-fs/hubfs/bq_7-gif.gif?width=454&height=291&name=bq_7-gif.gif)

8\. Once a Service Account has been created, click into it and navigate to the '**Keys**' tab.

![](https://help.mozartdata.com/hs-fs/hubfs/bq_3-gif.gif?width=536&height=306&name=bq_3-gif.gif)

9\. Click on the '**Add Key**' button. Then, click '**Create new key**' and select **JSON** for key type. Within a few seconds, the private key will be saved as a JSON file on your computer.

![](https://help.mozartdata.com/hs-fs/hubfs/bq_4-gif.gif?width=525&height=300&name=bq_4-gif.gif)

10\. Open the JSON file that is saved on your computer, then copy and paste the key into *Step 3* of the BigQuery setup form within Mozart.

 

11\. Click '**Connect**' to proceed. It will take about 60 seconds to finish connecting Mozart Data to your BigQuery data warehouse.

- [Getting Started](https://help.mozartdata.com/docs/getting-started?hsLang=en)
- [Core Features](https://help.mozartdata.com/docs/core-features?hsLang=en#main-content)

    - [Connectors & Data Sources](https://help.mozartdata.com/docs/core-features?hsLang=en#connectors-data-sources)
    - [Transforms](https://help.mozartdata.com/docs/core-features?hsLang=en#transforms)
    - [Tables](https://help.mozartdata.com/docs/core-features?hsLang=en#tables)
    - [Integrations](https://help.mozartdata.com/docs/core-features?hsLang=en#integrations)
    - [Settings](https://help.mozartdata.com/docs/core-features?hsLang=en#settings)
- [Advanced Usage](https://help.mozartdata.com/docs/advanced-usage?hsLang=en)
- [Changelog](https://help.mozartdata.com/docs/changelog?hsLang=en)
- [Reference](https://help.mozartdata.com/docs/reference?hsLang=en)

# Mozart Data

Mozart Data Help Center

Copyright © 2026, Mozart Data