About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Google BigQuery operations on Zapier

Start a workflow when this happens

New Job Completed — Triggers when a query job has completed processing successfully or unsuccessfully.
New Row — Triggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
Query Job Completed (With Row Data) — Triggers when a query job has completed processing successfully.
Updated Row — Triggers when an existing row is updated in a table in BigQuery.

Things Salesflare can make it do

API Request (Beta) — This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
Create Row — Creates a new row of data in a table. *Note:* Does not create a job.
Create Rows — Creates new rows of data in a table (accepts line items). *Note:* Does not create a job.
Delete Rows — Deletes row(s) in an existing table in BigQuery
Find or Create Record — Find or Create Record

Show 3 more actions

Look up existing records

Find One Row — Find a row by specifying a table, a WHERE clause, an optional ORDER BY.
Get Rows for Job Completed — Gets batch of rows from completed jobs in BigQuery

Google BigQuery operations on Make

Start a workflow when this happens

Watch Query Jobs Completed — Triggers when a query job has completed processing successfully or unsuccessfully.
Watch Rows — Triggers when a new row is inserted in a table.
Watch Tables — Triggers when a new table is created in a dataset.

Things Salesflare can make it do

Show 8 more actions

Get a Dataset — Returns the dataset specified by dataset ID.
Get a Table — Gets the specified table resource by table ID.
Make an API Call — Performs an arbitrary authorized API call.
Run a Query — Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.
Update a Dataset — Updates information in an existing dataset.
Update a Table — Updates information in an existing table.
Upload Data (Streaming) — Creates a new row of data in a table.
Upload a File — Uploads a new file.

Look up existing records

List Datasets — Lists all datasets in the specified project to which the user has been granted the READER dataset role.
List Jobs — Lists all jobs that user started in the specified project.
List Table Data — Lists the content of a table in rows.
List Tables — Lists all tables in the specified dataset.

Google BigQuery and Salesflare