Why Tablyne for BigQuery
A desktop BigQuery client that runs a free dry run before every query and puts a byte cap on every job.
Tablyne queries BigQuery from a desktop client and keeps one careless query from running up the bill, with a dry run before every query and a byte cap on every job.
BigQuery charges for the bytes a query reads. Tablyne treats that as the main risk. Every query goes through one gate. The gate first runs a dry run, which is free, and shows how many bytes the query would process and the approximate cost. The dry run cannot be skipped. Then every job is sent with a maximumBytesBilled limit, so BigQuery itself refuses a query that would read more than the cap. The default cap is 10 GiB, and you can change it per connection.
If the estimate is above the cap, Tablyne asks you to confirm raising the cap for that one run. If BigQuery gives no estimate, or only a minimum, the console says so and asks before it runs.
Read-only in this version
BigQuery connections in Tablyne are read-only. INSERT, UPDATE, DELETE, MERGE and DDL are refused. The connection form shows “Read-only (fixed)”.
Browsing costs nothing
The object tree uses BigQuery’s metadata API, not queries, so opening a connection and browsing datasets does not bill bytes.
One window with the rest of your stack
BigQuery sits next to your other connections. You can run a query here and open another engine in the next tab.