All categories
System
Access management
AI
Appflows - Technical
Billing
Billing and policy
Built-in apps
Business cases addon
Business Intelligence
Business Operations and ERPs
Calendar addon
Commerce
Communication
Community apps
Contacts module
Contracts addon
CRM and Sales tools
Customer Support
Database
Education
Features
File and Document Management
Forms Addon (Legacy)
Getting started with Boost.space
HR management
Internet of Things
Invoices module
IT and Development
Lifestyle
Marketing
Marketplace - Overview
Marketplaces
Modules and Addons
News monitor addon (legacy)
Notes addon
Offers addon
Orders module
Other
Pages addon
Policy
Process Management
Productivity
Products module
Records
Spaces
Surveys and Forms
System Settings (for Admins)
Tasks module
Travel
Users and teams
Wall addon
Warehouses addon
Website Building
Work hours addon
Integrations
Apps
Connections
Errors
Functions
Getting started with Boost.space Integrator
Integrator Modules
Mapping
Scenarios
Tools
Tutorials
List of applications
Table of Contents
Active
This application does not need additional settings. So you can make connection only by using your login credentials or by following the instructions below .

BigQuery

With BigQuery modules in Boost.space Integrator, you can monitor tables and completed query jobs, and create, retrieve, update, or delete datasets and tables in your BigQuery account.

To use the BigQuery modules, you must have a Google account and a project created. You can create an account at Google Cloud Platform.

Refer to the BigQuery API Documentation for a list of available endpoints.

[Note] Note
Boost.space Integrator‘s use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy.

Connect BigQuery to Boost.space Integrator

To establish the connection in Boost.space Integrator:

 

  1. Log in to your Boost.space Integrator 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 Console project client credentials. For more information, see the Create and configure a Google Cloud Console project for BigQuery section below.
  4. Click Sign in with Google.
  5. If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more BigQuery modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Create and configure a Google Cloud Console project for BigQuery

To connect to Boost.space Integrator using your own client credentials, you can create and configure a project in the Google Cloud Console.

Create a Google Cloud Console project for BigQuery

To create a Google Cloud Console project:

 

  1. Log in to the Google Cloud Console using your Google credentials.
  2. In the top menu, click 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.

Enable APIs for BigQuery

To enable the required APIs:

 

  1. Open the left navigation menu and go to APIs & Services > Library.
  2. Search for and enable the following APIs: BigQuery API.

Configure your OAuth consent screen for BigQuery

To configure your OAuth consent screen:

 

  1. In the left sidebar, click OAuth consent screen.
  2. Under User Type, select External.

    For more information regarding user types, refer to Google’s Exceptions to verification requirements documentation.

  3. Click Create.
  4. Fill in the required fields with your information.
  5. In the Authorized domains section, add make.com and boost.space.
  6. Click Save and continue.
  7. In the Scopes page, 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
  8. Click Save and continue.
  9. Optional: If your project will remain in the Testing publishing status, add test user emails on the Test users page, then click Save and continue.

Create your BigQuery client credentials

To create your client credentials:

 

  1. In the left sidebar, click Credentials.
  2. Click + Create Credentials > OAuth client ID.
  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 console.
  5. In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI: https://integrator.boost.space/oauth/cb/google/.
  6. Copy your Client ID and Client secret values and store them in a safe place.

You will use these values in the Client ID and Client Secret fields in Boost.space Integrator.

Build BigQuery Scenarios

After connecting the app, you can perform the following actions:

Dataset

  • List Datasets
  • Get a Dataset
  • Create a Dataset
  • Update a Dataset
  • Delete a Dataset

Table

  • Watch Tables
  • List Tables
  • Get a Table
  • Create a Table
  • Update a Table
  • Delete a Table

Table Data

  • Watch Rows
  • List Table Data
  • Upload Data (Streaming)
  • Update a File

Query Job

  • Watch Query Jobs Completed
  • List Jobs
  • Get Query Results by Job ID
  • Run a Query

Other

  • Make an API Call