Google BigQuery and Okta integrations and automations

Do everything in one place

Customize your Google BigQuery and Okta integration with the following triggers and actions.

Triggers

When this happens…

Google BigQuery
  • New job completed
    New job completed in BigQuery
  • New row
    New row in a table in BigQuery
  • New rows Batch
    New batch of rows in a table in BigQuery
  • Scheduled query Batch
    New scheduled query using custom SQL in BigQuery

    • Any other trigger you can think up

Okta
  • New events
    Triggers when a new event is created in Okta
  • New events Real-time
    Triggers immediately when a new event is created in Okta
  • Scheduled event search using filter Batch
    Scheduled event search using filter in Okta

    • Any other trigger you can think up

Actions

Do this…

Google BigQuery
  • Custom action
    Custom action in Google BigQuery (Custom)
  • Get batch of rows by Job ID Batch
    Get batch of rows from query result in BigQuery
  • Insert row
    Insert a row in table in BigQuery
  • Insert rows Batch
    Insert rows in table in BigQuery
  • Load data into BigQuery
    Load data into table on BigQuery
  • Load data from Google Cloud Storage into BigQuery
    Load data from Google Cloud Storage into table on BigQuery
  • Run custom SQL in BigQuery
    Run custom SQL in BigQuery
  • Select rows (Old) Batch
    Select rows asynchronously in a table in BigQuery
  • Select rows Batch
    Select rows in a table in BigQuery
  • Select rows using custom SQL (Old) Batch
    Select rows asynchronously using custom SQL in BigQuery
  • Select rows using custom SQL Batch
    Select rows using custom SQL in BigQuery
  • Select rows using custom SQL and insert into table Batch
    Select rows using custom SQL and insert into table in BigQuery

    • Any other action you can think up

Okta
  • Custom action
    Custom action in Okta (Custom)
  • Activate user
    Activate user in Okta
  • Add user to group
    Adds an existing user to a group in Okta
  • Create user
    Create user in Okta
  • Deactivate user
    Deactivate user in Okta
  • Delete user
    Delete user in Okta
  • Expire an existing user password
    Expire an existing user’s password in Okta
  • Get group members Batch
    Retrieves the list of members of a group in Okta
  • Get groups by name Batch
    Retrieves groups by name in Okta
  • Get user by ID
    Get user by ID in Okta
  • Get user groups Batch
    Get user groups in Okta
  • Get recent log on events by IP address Batch
    Get recent log on events by IP address in Okta
  • Get recent log on events by user Batch
    Get recent log on events by user in Okta
  • List applications assigned to user Batch
    List applications assigned to user in Okta
  • Remove user from group
    Removes an existing user from a group in Okta
  • Reset forgotten user password
    Reset an existing user’s forgotten password in Okta
  • Reset user password
    Reset user password in Okta
  • Search Users Batch
    Search users in Okta
  • Suspend user
    Suspends an existing user in Okta
  • Unsuspend user
    Unsuspend an existing user in Okta
  • Update user
    Update user in Okta

    • Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.
  • 1000s of ready-to-use templates
  • Accelerate work with intelligent automation
  • Do it yourself, faster
  • Build bots. Put them to work

Market leaders run on Workato

  • mgm
  • adobe
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo