Browse BigQuery without editing it

Browse projects, datasets, tables and views in BigQuery, read the schema and preview rows for free. Results stay read-only.

Tablyne browses BigQuery and does not edit it in this version. Results open as read-only grids, and the console says “BigQuery results are read-only in this version”. There are no staged edits, because the app does not write to BigQuery.

The tree is free

The sidebar lists your billing project and any pinned projects, then datasets, then tables and views. It reads only metadata, so browsing is not billed. The tree shows whether a table is partitioned or clustered, and marks external tables, snapshots and materialized views. It also lists routines and models. If you lack permission on a dataset, the tree says the list could not be read. Lists longer than 2,000 items are cut, and the tree says so.

A table tab

  • Structure shows each column with its type, mode and description.
  • Details shows the object type, partitioning, clustering, whether a partition filter is required, row count, size and location.
  • Preview reads rows straight from storage. It is not a query and bills no bytes. You click to read it, and it never loads by itself. Tablyne warns that storage order is not guaranteed.

Views and external tables cannot be previewed this way. For those, Tablyne tells you to open them in the console, where the SELECT goes through the estimate and the cap.

Jobs

A jobs tab lists recent jobs of the project, with state, user, duration, bytes processed and billed, and approximate cost. You can cancel your own jobs. Cancelling another user’s job is not offered. To list the jobs of all users, your account needs the bigquery.jobs.listAll permission.