Google Cloud BigQuery Connector
Quickly build integrations connecting your B2B SaaS to Google Cloud BigQuery.
About the Google Cloud BigQuery Connector
Manage datasets, tables, jobs, routines, and models in Google Cloud BigQuery, and retrieve query job results.
Actions
Actions are tasks that you add to your workflow. One action might update records in a third-party API, while another action might fetch a list of records.
Jump to actions
Triggers
Triggers cause workflows to run. Some triggers run on a schedule. Others are invoked by a webhook request, or poll an API for new data. If a connector does not have a built-in trigger, you can use a generic scheduled or webhook trigger.
Jump to triggers
FAQs
Learn more about this connector and related integration functionality.
Jump to FAQs
Actions
| Action Name | Action Description |
|---|---|
| Create Dataset | Creates a new empty dataset. |
| Update Dataset | Updates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. |
| Get Dataset | Returns the dataset specified by datasetID. |
| List Datasets | Lists all datasets in the specified project to which the user has been granted the READER dataset role. |
| Delete Dataset | Deletes the dataset specified by the datasetId value. Before you can delete a dataset, you must delete all its tables, either manually or by specifying deleteContents. Immediately after deletion, you can create another dataset with the same name. |
| Cancel Job | Requests that a job be cancelled. |
| Create Job | Starts a new asynchronous job. |
| Delete Job | Requests the deletion of the metadata of a job. |
| Get Job | Returns information about a specific job. |
| Get Query Job Results | Receives the results of a query job. |
| List Jobs | Lists all jobs that you started in the specified project. |
| Query Job | Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout. |
| Raw Request | Send raw HTTP request to Google Cloud BigQuery |
| Get Model | Gets the specified model resource by model ID. |
| List Models | Lists all models in the specified dataset. Requires the READER dataset role. After retrieving the list of models, you can get information about a particular model by calling the models.get method. |
| Delete Model | Deletes the model specified by model ID from the dataset. |
| Update Model | Patch specific fields in the specified model. |
| Set Policy | Sets the access control policy on the specified resource. |
| Get Policy | Gets the access control policy for a resource. |
| Get Service Account | Receives the service account for a project used for interactions with Google Cloud KMS |
| List Projects | Lists projects to which the user has been granted any project role. |
| Create Routine | Creates a new routine in the dataset. |
| List Routines | Lists all routines in the specified dataset. |
| Get Routine | Gets the specified routine resource by routine ID. |
| Update Routine | Updates information in an existing routine. |
| Delete Routine | Deletes the routine specified by routine ID from the dataset. |
| Table Data Insert All | Streams data into BigQuery one record at a time without needing to run a load job. |
| Create Table | Creates a new, empty table in the dataset. |
| List Tables | Lists all tables in the specified dataset. |
| Get Table | Gets the specified table resource by table ID. |
| Update Table | Updates information in an existing table. |
| Delete Table | Deletes the table specified by table ID from the dataset. |
| Patch Table | Patch information in an existing table. |
Triggers
| Trigger Name | Trigger Description |
|---|---|
| PubSub Notification | Receive PubSub notifications from Google Cloud when events occur. |
| New Jobs | Retrieves existing and ongoing jobs in a specified BigQuery project. Load history once, check for new jobs on a schedule, or both. |
API Connectors
Integrate with customers' other SaaS apps, fast
Prismatic’s API connectors make it easy to integrate other SaaS apps – without reinventing the wheel. Triggers, actions, and auth are fully handled. And they work with all of Prismatic’s options for building integrations:
- Empower non-devs with a low-code designer
- Give devs freedom to build completely in code
- Let customers create their own workflows
