--- title: BigQuery slug: google-bigquery image: https://make-cxp-documentation.ams3.digitaloceanspaces.com/apps-center-icons/PREVIEW_google-bigquery.png docTags: createdAt: 2025-02-03T13:28:13.884Z --- With the BigQuery app in Make, you can monitor tables and completed query jobs, and manage the datasets and tables in your BigQuery account. # Requirements To use the BigQuery app in Make, you must have a [Google account](http://account.google.com/) and a project created. You can create an account at [Google Cloud Platform](https://console.cloud.google.com/). :::hint{type="info"} Make's use and transfer of information received from Google APIs to any other app will adhere to [Google API Services User Data Policy](https://developers.google.com/terms/api-services-user-data-policy). ::: # Connect BigQuery to Make To get started, you must first create a connection between BigQuery and Make, allowing the two services to communicate. To create the connection, you need to: 1. Log in to your Make account, add a BigQuery module to your scenario and click **Create a connection**. Note: If you add a module with an `instant` tag, click **Create a webhook**, then **Create a connection**. 2. Optional: In the **Connection name** field, enter a name for the connection. 3. Optional: Switch on the **Show advanced settings** toggle and enter your Google Cloud Platform project client credentials. For more information, see the [Create and configure a Google Cloud Platform project for BigQuery section](#) below. 4. Click **Sign in with Google**. 5. If prompted, authenticate your account and confirm access. You've successfully created the connection and can now use the BigQuery app in your scenarios. If you want to make changes to your connection in the future, follow the steps [here](docId\:SO88FM6pkT0G-adKDDfzZ). ::::ExpandableHeading # Create and configure a Google Cloud Platform project for BigQuery To connect to Make using your own client credentials, you can create and configure a project in the Google Cloud Platform. ### Create a Google Cloud Platform project for BigQuery To create a Google Cloud Platform project: 1. Log in to the [Google Cloud Platform](https://console.cloud.google.com/) using your Google credentials. 2. On the welcome page, click **Create or select a project** > **New project**. 3. Enter a **Project name** and select the **Location** for your project. 4. Click **Create**. 5. In the top menu, check if your new project is selected in the **Select a project** dropdown. If not, select the project you just created. :::hint{type="info"} To create a new project or work in the existing one, you need to have the `serviceusage.services.enable` permission. If you don’t have this permission, ask the Google Cloud Platform Project Owner or Project IAM Admin to grant it to you. ::: ### Enable APIs for BigQuery To enable the required APIs: 1. Open the left navigation menu and go to **APIs & Services** > **Library**. 2. Search for the following API: **BigQuery API**. 3. Click **BigQuery API**, then click **Enable**. ### Configure your OAuth consent screen for BigQuery To configure your OAuth consent screen: 1. In the left sidebar, click **Google Auth Platform**. 2. Click **Get Started**. 3. In the **Overview** section, under **App information**, enter *Make* as the app name and provide your Gmail address. Click **Next**. 4. Under **Audience**, select **External**. For more information regarding user types, refer to [Google's Exceptions to verification requirements documentation](https://support.google.com/cloud/answer/9110914#exceptions-ver-reqts). 5. Under **Contact Information**, enter your Gmail address. 6. Under **Finish**, agree to the Google User Data Policy. 7. Click **Continue** > **Create**. 8. In the **Branding** section, under **Authorized domains**, add `make.com` and `integromat.com`. Click **Save**. 9. Optional: In the **Audience** section, add your Gmail address on the **Test users** page, then click **Save and continue** if you want the project to remain in the **Testing** publishing status. 10. In the **Data Access** section, click **Add or remove scopes**, add the following scopes, and click **Update**: - `https://www.googleapis.com/auth/userinfo.email` - `https://www.googleapis.com/auth/bigquery` - `https://www.googleapis.com/auth/bigquery.readonly` - `https://www.googleapis.com/auth/drive.readonly` 11. Click **Save**. :::hint{type="info"} **Publishing Status** **Testing:** If you keep your project in the **Testing** status, you will be required to reauthorize your connection Make every week. To avoid weekly reauthorization, update the project status to **In production**. **In production:** If you update your project to the **In production** status, you will not be required to reauthorize the connection weekly. To update your project's status, go to the **Google Auth Platform**, the **Audience** section, and click **Publish app**. If you see the notice **Needs verification**, you can choose whether to go through the [Google verification process](https://support.google.com/cloud/answer/13463073?authuser=1\&visit_id=638718595933013017-1855034908\&rd=1) for the app or to connect to your unverified app. Currently connecting to unverified apps works in Make, but we cannot guarantee the Google will allow connections to unverified apps for an indefinite period. For more information regarding the publishing status, refer to the Publishing status section of [Google's Setting up your OAuth consent screen help](https://support.google.com/cloud/answer/10311615#zippy=). ::: ## Create your BigQuery client credentials To create your client credentials: 1. In Google Auth Platform, click **Clients**. 2. Click **+ Create Client**. 3. In the **Application type** dropdown, select **Web application**. 4. Update the **Name** of your OAuth client. This will help you identify it in the platform. 5. In the **Authorized redirect URIs** section, click **+ Add URI** and enter the following redirect URI: `https://www.integromat.com/oauth/cb/google/`. 6. Click **Create**. 7. Click the OAuth 2.0 Client you created, copy your **Client ID** and **Client secret** values, and store them in a safe place. You'll use these values in the **Client ID** and **Client Secret** connection fields in Make. :::: # BigQuery modules After connecting to the app, you can use the following types of modules to build your scenarios. :::ExpandableHeading **Dataset** - List Datasets - Get a Dataset - Create a Dataset - Update a Dataset - Delete a Dataset ::: :::ExpandableHeading **Table** - Watch Tables - List Tables - Get a Table - Create a Table - Update a Table - Delete a Table ::: :::ExpandableHeading **Table Data** - Watch Rows - List Table Data - Upload Data (Streaming) - Update a File ::: :::ExpandableHeading **Query Job** - Watch Query Jobs Completed - List Jobs - Get Query Results by Job ID - Run a Query ::: :::ExpandableHeading **Other** - Make an API Call ::: # Templates You can look for BigQuery templates in [Make's template gallery](https://www.make.com/en/templates), where you'll find thousands of pre-created scenarios. # BigQuery resources - [BigQuery API Documentation](https://cloud.google.com/bigquery/docs/reference/rest) - [BigQuery Product Documentation](https://cloud.google.com/bigquery/docs/introduction)