| Active with remarks |
|---|
| This application needs additional settings. Please follow the documentation below to create your own connection. |
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]](https://docs.boost.space/wp-content/themes/bsdocs/docs-parser/HTML/css/image/note.png) |
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. |
To establish the connection in Boost.space Integrator:
- 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
instanttag, 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 Platform project client credentials. For more information, see the Create and configure a Google Cloud Platform project for BigQuery 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.
To connect to Boost.space Integrator using your own client credentials, you can create and configure a project in the Google Cloud Platform.
NOTE! – In the field “authorised domains” type: boost.space and celonis.com
NOTE! – In the field “Authorised redirect URLs” type: https://integrator.boost.space/oauth/cb/google and https://integrator.boost.space/oauth/cb/google-restricted
|
Note |
|---|---|
| Publishing Status
Testing: If you keep your project in the Testing status, you will be required to reauthorize your connection in Boost.space Integrator 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 for the app or to connect to your unverified app. Currently connecting to unverified apps works in Boost.space Integrator, 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. |
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