Google BigQuery and PostgreSQL integrations and automations

Do everything in one place

Customize your Google BigQuery and PostgreSQL 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

PostgreSQL
  • New row
    New row in a table in PostgreSQL
  • New rows Batch
    New batch of rows in a table in PostgreSQL
  • New/updated row
    New/updated row in a table in PostgreSQL
  • New/updated rows Batch
    New/updated batch of rows in a table in PostgreSQL

    • 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
    Get batch of rows from query result in BigQuery
  • Insert row
    Insert a row in table in BigQuery
  • Insert rows Bulk
    Insert rows in table in BigQuery
  • Insert rows Batch
    Insert rows in table in BigQuery
  • Load data into BigQuery
    Load data into table on BigQuery
  • Run custom SQL in BigQuery
    Run custom SQL in BigQuery
  • Select rows
    Select rows in a table in BigQuery
  • Select rows using custom SQL
    Select rows using custom SQL in BigQuery

    • Any other action you can think up

  • Show all 9
PostgreSQL
  • Delete rows
    Delete rows in a table in PostgreSQL
  • Export query result Bulk
    Export result of custom SQL in PostgreSQL
  • Insert row
    Insert row in a table in PostgreSQL
  • Run custom SQL
    Run custom SQL in PostgreSQL
  • Select rows
    Select rows in a table in PostgreSQL
  • Select rows using custom SQL
    Select rows using custom SQL in PostgreSQL
  • Update rows
    Update rows in a table in PostgreSQL
  • Upsert rows Batch
    Upsert batch of rows in a table in PostgreSQL

    • Any other action you can think up

  • Show all 8

Let us tailor your Google BigQuery and PostgreSQL integrations

Pre-built Google BigQuery and PostgreSQL Automations

See more

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