BigQuery Mate

Companion tool for Google BigQuery UI used by myself and my peers at Viant Inc. Adds some extra functionality to BQ Native UI

What is BigQuery Mate?

BigQuery Mate is a handy Chrome extension designed to enhance the Google BigQuery user interface with an array of convenient features. Aimed at making workflow smoother, it allows users to control the Navigation Panel, estimate cost based on processed bytes, support for Parametrized Query, find/replace functionality, provide keyboard shortcuts, and a lot more. It keeps updating to keep up with Google's constant adjustments on BigQuery's UI, ensuring optimum efficiency.

Download

Extension stats

By: Mikhail Berlyant

View on Chrome Web Store

Users: 4,000+

Rating: 4.35 (23)

Version: 4.0 (Last updated: 2019-11-09)

Creation date: 2019-11-08

Risk impact: Very high risk impact

Risk likelihood: Very low risk likelihood

Manifest version: 2

Permissions:

*://bigquery.cloud.google.com/*
*://console.cloud.google.com/bigquery*
*://cloud.google.com/bigquery*
*://us-central1-mb-sandbox-01.cloudfunctions.net/*
tabs
activeTab
contextMenus

Size: 210.94K

Email: mb*****@att.net

Ranking

# 15891 ▼ 44

Other rankings

#3778 in Workflow & Planning ▲ 2

#30 in query keyword 6 ▼ 3

#49 in cost keyword 8 ▲ 3

#126 in auto save keyword 7 ▲ 4

#130 in replace keyword 21 ▼ 3

Upgrade to see more rankings

Other platforms

Not available on Firefox

Not available on Edge

Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.

Extension summary

Analyze keywords

Now: Finally (based on demand) decided to add BQ Mate for New UI - started with just cost estimation (most popular feature till now). Will see what next based on feedback and mood :o)

Previous releases: CHANGE: Pivot Button moved to front (previously was available with JSON view only) - Build Pivot with Data available on current Page. IMPORTANT - to cover more data (up to 500 rows) - expand Result Panel with + Button NEW: Full Screen View Button FIX: issue with "Add Fields" feature NEW: Added Keyboard Shortcuts to view previous/next page - Ctrl-Left, Ctrl-Right and first/last page - Ctrl-Down, Ctrl-Up (When previewing complete tables or when looking at query results) Note: Mac users to use Alt with respective Arrows NEW: Support for BigQuery Named Parameters (Magnus style Parameters are still supported) FIX: Parameter replacement breaks UDFs FIX: Parameters not always replaced correctly respective SQL NEW: Added Switch SQL Version button for quick switch between Legacy and Standard SQL. Also ALT-L shortcut can be used for this! Double Click or SHIFT-ALT-L saves current SQL Version as default. NEW & IMPROVED: Query Outline; From Context Menu or Mate toolbar FIX: Keywords in Standard SQL Mode FIX: Support for "Run Selected" with CTRL-E or CTRL-F5

User reviews

These summaries are automatically generated weekly using AI based on recent user reviews. Chrome Web Store does not verify user reviews, so some user reviews may be inaccurate, spammy, or outdated.

Pros

Very helpful for estimating costs in BigQuery
Increases efficiency with features like find/replace
Adds hidden functionalities that improve user experience
Easy to navigate and makes using BigQuery easier

Cons

Does not work with the new BigQuery UI
Lack of clarity on compatibility with different UIs
Prompted users to purchase software from Potens.io unexpectedly

Most mentioned

Incompatibility with the new UI
Need for updates to support new UI
Cost estimation feature is valuable
Overall efficiency improvements

Recent reviews

It's not working. Am-I the only one ?

Yufeng LIANG, 2024-03-20

Doesn't work with new UI anymore.

Alexander Belozerov, 2022-07-04

I've used this extension plenty in the past for getting a quick cost estimate. However, with the new UI this is no longer possible. Would it be possible to update the extension to make it work with the new UI?