Connect Looker and Oracle Database

Both apps 34Looker 22Oracle Database 12

• Trigger
  New Dashboard

  Triggers when a new dashboard is created in Looker.

• Trigger
  New Look

  Triggers when a new Look is saved in Looker.

• Trigger
  New User

  Triggers when a new user is added to Looker.

• Action
  Add Group

  Creates a new user group in Looker (admin only).

• Action
  Add Role(s) to User

  Sets the roles assigned directly to a Looker user, replacing their current direct roles.

• Action
  Add Scheduled Plan

  Creates a scheduled plan that delivers a Look, dashboard, LookML dashboard or query to one or more destinations on a recurring schedule.

• Action
  Add User to Group

  Adds a user to a Looker group.

• Action
  Create Credentials - Email

  Adds an email login to a Looker user.

• Action
  Create Render Task

  Starts rendering a Look to an image or PDF; use Get Render Task Results with the returned ID once it finishes.

• Action
  Create User

  Creates a new user in Looker with the given name and details.

• Action
  Delete User

  Deletes a user from Looker.

• Action
  Find User

  Finds Looker users matching an email or name.

• Action
  Get Dashboard

  Returns the full details of a Looker dashboard, including its tiles, filters and layouts.

• Action
  Get Look

  Returns a saved Look's details, including its title, folder, owner, URLs and the query behind it.

• Action
  Get Render Task Results

  Returns the image or PDF file produced by a completed render task.

• Action
  Get User

  Returns a Looker user's details by user ID, including name, email, roles, groups and credentials.

• Action
  List Dashboards

  Returns all active dashboards in your Looker instance with summary details such as id, title and folder.

• Action
  List Groups

  Returns the user groups in your Looker instance, optionally filtered by ID or content access.

• Action
  List Looks

  Returns all active Looks the connected user has access to, with their titles, folders and owners.

• Action
  Run Look

  Runs a saved Look and returns its result rows.

• Action
  Send Password Reset or Account Setup Email

  Sends a Looker user a password reset email, or an account setup email if they have not set up their account yet.

• Action
  Update User

  Updates a Looker user's name, home folder, locale or disabled status, and returns the updated user.

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

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