Air and Google BigQuery integrations and automations

Seamlessly connect Air and Google BigQuery. Automate workflows, and boost efficiency with Workato.

Rating

4.9

Pre-built

150+

integrations

Total

100+

active users

avg

2 min

to connect

Custom Connections

Available

via HTTP connector

Market leaders run on Workato

  • monday.svg
  • box.svg
  • hp-2.svg
  • atlassian.svg
  • cisco.png

Build Powerful Workflows, fast

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

Actions

Do this…

Air
  • Delete asset
    Delete asset in Air
  • Remove tag from asset version
    Remove tag from asset version in Air
  • Delete board
    Delete board in Air
  • Remove asset from board
    Remove asset from board in Air
  • Remove guest from board
    Remove guest from board in Air
  • Delete custom field
    Delete custom field in Air
  • Delete custom field value
    Delete custom field value in Air
  • Delete library
    Delete library in Air
  • Delete tag
    Delete tag in Air
  • List assets
    List assets in Air
  • Get asset
    Get asset in Air
  • List asset's parent boards
    List asset's parent boards in Air
  • List asset CDN links
    List asset CDN links in Air
  • List asset versions
    List asset versions in Air
  • Get asset version
    Get asset version in Air
  • Get asset version download URL
    Get asset version download URL in Air
  • List boards
    List boards in Air
  • Get board
    Get board in Air
  • List board guests
    List board guests in Air
  • List custom fields
    List custom fields in Air
  • Get custom field
    Get custom field in Air
  • Get import status
    Get import status in Air
  • List libraries
    List libraries in Air
  • Get library
    Get library in Air
  • List roles
    List roles in Air
  • List tags
    List tags in Air
  • Activate or deactivate CDN link
    Activate or deactivate CDN link in Air
  • Update asset version
    Update asset version in Air
  • Update board
    Update board in Air
  • Update board guest role
    Update board guest role in Air
  • Update custom field
    Update custom field in Air
  • Update custom field value
    Update custom field value in Air
  • Update library
    Update library in Air
  • Update tag
    Update tag in Air
  • [Deprecated] Create evergreen CDN link (legacy)
    [Deprecated] Create evergreen CDN link (legacy) in Air
  • Create CDN link
    Create CDN link in Air
  • [Deprecated] Create version-pinned CDN link (legacy)
    [Deprecated] Create version-pinned CDN link (legacy) in Air
  • Add tag to asset version
    Add tag to asset version in Air
  • Create board
    Create board in Air
  • Add assets to board
    Add assets to board in Air
  • Add guest to board
    Add guest to board in Air
  • Complete multipart upload
    Complete multipart upload in Air
  • Create custom field
    Create custom field in Air
  • Add custom field value
    Add custom field value in Air
  • Import asset from URL
    Import asset from URL in Air
  • Create library
    Create library in Air
  • Create tag
    Create tag in Air
  • Upload asset
    Upload asset in Air
  • Get multipart upload part URL
    Get multipart upload part URL in Air
  • Set custom field value on asset
    Set custom field value on asset in Air
  • Set custom field value on board
    Set custom field value on board in Air

    • Any other action you can think up

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

One platform

  • Power
  • Agility
  • Speed
  • Innovation