BigQuery

Modified on Fri, 16 Aug at 4:57 PM

With BigQuery modules in Make, 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

Make'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 Make

To establish the connection in Make:

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.
Optional: In the Connection name field, enter a name for the connection.
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 <app name> section below.
Click Sign in with Google.
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

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
Write Query

Other

Make an API Call