BigQuery

BigQuery Integration

Run SQL queries on datasets and tables at scale

Data & Analytics 7 actions OAuth 2.0 (sign in to authorise)

Start automating BigQuery

What you can automate with BigQuery

Drag any of these 7 actions into a process — no code, no API wrangling.

Get Query Results

Get results of a completed query job

Get Table

Get table schema/metadata

Insert Rows

Stream rows into a table

List Datasets

List all datasets in a project

List Jobs

List recent jobs

List Tables

List tables in a dataset

Run Query

Execute a SQL query

How the BigQuery connection works

1. Authenticate

BigQuery uses oAuth 2.0 (sign in to authorise). Save the connection once and reuse it across every process.

2. Build the process

Drop BigQuery steps onto the process map alongside desktop, browser, Excel and email steps.

3. Run it attended or unattended

Trigger on a schedule, an email, or a file landing in a folder. Credentials stay encrypted and every run is audited.

Because BigQuery has an API, Automize talks to it directly in the cloud — no bot needed on a desktop. Where a system has no API, an Automize bot drives its interface instead.

Other Data & Analytics connectors

Automate BigQuery in 7 days

We build one working BigQuery automation in your business inside a week, at a fixed price.