Google BigQuery

Google BigQuery is a serverless data warehouse that helps analyze datasets and support informed decision-making.

Actions

  • getDataset: Retrive the dataset specified by datasetID

  • getJob: Retrieve information about a specific job

  • getQueryResults: Retrieve the results of a query job

  • getResumableSession: Retrive the resumable session URI

  • getTable: Retrieve the specified table resource by table ID

  • getUploadStatus: Retrieve the upload status of a file

  • listDatasets: List all datasets in the specified project to which you have been granted the READER dataset role

  • listJobs: List all jobs that you started in the specified project

  • listProjects: Lists all projects where the user has been assigned a project role

  • listTableData: Retrieve table data from a specified set of rows

  • listTables: List all tables in the specified dataset

  • query: Run a BigQuery SQL query and return results if the query completes within a specified timeout

  • asynchronousQuery: Run a query against BigQuery data

  • cancelJob: Cancels a specific job. The request returns immediately, and the client must poll the job status to confirm if the cancellation was successful.

  • copyTable: Copy an existing table to another new or existing table

  • deleteDataset: Delete 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

  • deleteTable: Delete the table specified by tableId from the dataset. If the table contains data, all the data is deleted

  • extract: Export a BigQuery table to Google Cloud Storage

  • insertDataset: Create a new empty dataset

  • insertTable: Create a new, empty table in the dataset

  • patchDataset: Update information in an existing dataset. Update replaces the entire dataset resource, whereas Patch replaces fields that are provided in the submitted dataset resource

  • patchTable: Update information in an existing table. Update replaces the entire table resource, whereas Patch replaces fields that are provided in the submitted table resource

  • updateDataset: Update information in an existing dataset. Update replaces the entire dataset resource, whereas Patch replaces fields that are provided in the submitted dataset resource

  • updateTable: Update information in an existing table. Update replaces the entire table resource, whereas Patch replaces fields that are provided in the submitted taco-salesforce_bulk_v2_data_loaderble resource

  • uploadFile: Upload the file to a particular location

Custom Actions

You can use this connector to create your own custom actions for performing specific tasks. The actions that you create look and work exactly like the other actions do.

Learn more about how to create custom actions.