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

Stats

By: Mikhail Berlyant

View on Chrome Web Store

Users: 5,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

Stats date:

Chrome-Stats Rank

# 14027 ▼ 105

Other rankings

#3248 in Workflow & Planning ▲ 6

#26 in query keyword 5 ▼ 8

#40 in cost keyword 5 ▼ 2

#99 in panel keyword 21 ▼ 2

#109 in replace keyword 11 ▼ 1

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.

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

User reviews summary

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

Useful functionalities within Google BigQuery
Helps save costs on queries
Enriches the BigQuery Console with additional functionality
Great for parameter substitution in template queries

Cons

Does not support the new BigQuery interface
Some users have experienced issues with functionality
Not clear on compatibility with new UI

Most mentioned

Useful functionalities within Google BigQuery
Does not support the new BigQuery interface
Enriches the BigQuery Console with additional functionality

Recent reviews

Any chance to make it work on Consile UI in addition to Classic UI?

Slava Kalashnikov, 2020-01-27

Please add all (or most of) functions to Console UI. Thanks in advance

Slava Kalashnikov, 2020-01-27

Any chance to make it work on Consile UI in addition to Classic UI?

Slava Kalashnikov, 2020-01-27

View all user reviews

Safety

Risk impact

BigQuery Mate is very risky to use and it requires a lot of sensitive permissions. Avoid installing this extension unless you absolutely trust this publisher.