Skip to content

Last updated

Databases and warehouses · data connector

Automated Google BigQuery reports, delivered on schedule

Rahoto connects to Google BigQuery with a service-account key, or through Google sign-in with read-only BigQuery access. It discovers the tables and views in your project's datasets, or in one dataset you name, and runs queries in Google BigQuery with pushdown.

Connect Google BigQuery Read connection guidance

What Rahoto reads

Your tables and views

Rahoto reads the structure from Google BigQuery itself: every table and view in the schema it is pointed at, with its columns and types. Nothing is fixed in advance, so the report sees the same tables your team does.

How you connect

What you need before connecting

Sign-in
  • A Google Cloud service-account key (JSON)
  • Google sign-in (OAuth)
Access requested

https://www.googleapis.com/auth/bigquery.readonly

Choosing what to read
After sign-in, Rahoto lists the Google Cloud projects that sign-in can see, and you pick from the list.
You provide
  • A service-account key (JSON), for service-account sign-in (optional)
  • The project that holds the data (optional)
  • One dataset, to read only that dataset (optional)

Connectors read from your sources and are read-only by default. See the connection guidance for the steps.

How it refreshes

Refreshed on your schedule

Refresh mode: Snapshot.

  • On each scheduled run Rahoto takes a fresh snapshot of the data and rebuilds the report from it.
  • You can preview the data before you bind it to the page.
  • Charts and tables can also query Google BigQuery directly, with the query work pushed down to it.
  • Before an issue goes out, Rahoto checks the pages and notices when a source changed shape.

Where the report goes

Delivered where your readers already work

Slack
thread or channel
Teams
channel post
Email
inline or attached
Web
viewer or embed
Webhook
your endpoint
S3
bucket drop
Drive
shared folder
SFTP
your server

Web publishing is on every plan; the other seven channels come with every paid plan. PDF, PowerPoint and PNG travel on any of them.

An example report

Monthly management report

The first working day of each month, built from Google BigQuery.

  1. A cover with the month and the business unit
  2. A headline page of the figures your team defines, each bound to a table, view or query
  3. Charts and tables bound to the same governed tables
  4. Commentary pages written in the editor beside the numbers
  5. An appendix of definitions, so readers know where each figure comes from

The structure of a report, with no figures shown. You design the pages; Rahoto binds them to the data and sends them on schedule. See finished examples in the sample gallery.

Connect Google BigQuery and set the schedule

Bind it into the document, check a run, and choose where it goes.

Start 14-day trial Read connection guidance