Google BigQuery

Google BigQuery is a popular serverless data warehouse which provides efficient functions to help you analyze your big data and make informed decisions.

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: List all projects to which you have been granted 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 returns results if the query completes within a specified timeout

  • asynchronousQuery: Run a query against BigQuery data

  • cancelJob: Cancel a specific job. This call will return immediately, and the client will need to poll for the job status to see if the cancel completed successfully

  • 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 will be 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 only 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 only 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 only 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 only replaces fields that are provided in the submitted table resource

  • uploadFile: Upload the file to particular location

Custom Actions

Google BigQuery connector also lets you create your own custom actions for performing specific tasks. The actions you create look and work exactly like the other actions do.

Learn more about how to create custom actions.