Connect Google BigQuery and OpsGenie

Both apps 29Google BigQuery 14OpsGenie 15

• Trigger
  New Job Completed

  Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

• Trigger
  New Row

  Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

• Trigger
  Query Job Completed (With Row Data)

  Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

• Trigger
  Updated Row

  Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

• Action
  Create Row

  Creates a new row of data in a table. Note: Does not create a job.

• Action
  Create Rows

  Creates new rows of data in a table (accepts line items). Note: Does not create a job.

• Action
  Delete Rows

  Deletes every row in a table whose match column equals the value you give.

• Action
  Find One Row

  Finds the first row in a table whose column equals the value you give.

• Action
  Get Rows for Job Completed

  Returns the result rows of a finished query job.

• Action
  Import Data

  Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

• Action
  List Datasets

  Returns the datasets in a Google Cloud project.

• Action
  List Tables

  Returns the tables in a BigQuery dataset.

• Action
  Run a Query

  Runs a SQL query against a table in BigQuery.

• Action
  Update Row(s)

  Updates every row in a table whose match column equals the value you give, setting the columns you choose.

• Trigger
  New alert

  Triggers when a new alert is created in OpsGenie, optionally limited to alerts matching a search query.

• Action
  Acknowledge alert

  Acknowledges an OpsGenie alert, optionally adding a note. The request is processed asynchronously and returns a request id.

• Action
  Add note to alert

  Adds a note to an existing OpsGenie alert. The note is processed asynchronously; the returned request id can be used to check its status.

• Action
  Assign alert

  Assigns an OpsGenie alert to a user as its owner.

• Action
  Close alert

  Closes an OpsGenie alert identified by its id, tiny id or alias. Closing is processed asynchronously and returns a request id.

• Action
  Close incident

  Closes an OpsGenie incident, optionally adding a note.

• Action
  Create Alert

  Creates a new alert in OpsGenie with a message, optional priority, responders, tags and custom details.

• Action
  Delete alert

  Deletes an OpsGenie alert by its id, tiny id or alias. The deletion is processed asynchronously and returns a request id.

• Action
  Get alert

  Returns a single OpsGenie alert, looked up by its id, tiny id or alias.

• Action
  Get incident

  Returns an OpsGenie incident by its id or tiny id, including its message, status, priority, responders, tags and custom properties.

• Action
  List alerts

  Returns alerts in your OpsGenie account, optionally filtered by a search query or a saved search, and sorted by the field you choose.

• Action
  List incidents

  Returns incidents matching a search query, sorted as requested.

• Action
  List schedules

  Returns all on-call schedules in the OpsGenie account, optionally with their rotations.

• Action
  List teams

  Returns all teams in the OpsGenie account, with each team's id, name and description.

• Action
  List users

  Returns the users in your Opsgenie account, optionally filtered by a search query and sorted.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.