Business Intelligence

BigQuery

7min

With the BigQuery app in , 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 , you must have a Google account and a project created. You can create an account at Google Cloud Platform.

'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 

To get started, you must first create a connection between BigQuery and , allowing the two services to communicate.

To create the connection, you need to:

  1. Log in to your  account, add a BigQuery module to your  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 . If you want to make changes to your connection in the future, follow the steps here.

BigQuery modules

After connecting to the app, you can use the following types of modules to build your .

  • Watch Tables
  • List Tables
  • Get a Table
  • Create a Table
  • Update a Table
  • Delete a Table
  • Watch Rows
  • List Table Data
  • Upload Data (Streaming)
  • Update a File
  • Watch Query Jobs Completed
  • List Jobs
  • Get Query Results by Job ID
  • Run a Query
  • Make an API Call

Templates

You can look for BigQuery templates in Make's template gallery, where you'll find thousands of pre-created .

BigQuery resources