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
Overview
What is 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.
SCREENSHOT
SUMMARY
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
NEW: Contextual Help via F1 or Right-Click Menu
FIX: Quick fix for Thousands Separator for null and empty
FIX: Quick fix for Datasets Filter as Google yet another time changing stuff around!
NEW: Thousands Separator for numeric fields!
Features:
1. Control size of the Navigation Panel (retired since Jan.31 2016)
2. Hide/Show Navigation Panel
3. Datasets Filtering
4. Filtered / Total Datasets Count
5. Monetary Cost estimation based on processed bytes
6. Keywords Auto-Capitalization
7. Comment/Uncomment Selection or Outside Selection
8. Support for Parametrized Query / Saved Query with Parameters
9. Tables Decoration / Manipulation
10. Find / Replace Functionality (with support for regular expressions)
11. Tabs Auto naming after query name (saved query)
12. Navigator: list of all BQ sessions across your PC with quick info and ability to jump to
New in v1.1:
13. Query Outline
14. Extended Result Panel
15. F5 to execute query
New in v1.2:
16. Interactive Pivots / Charts of Query Result
New in v1.4:
17. Search / Filter Recent Queries
New in v1.5:
18. Tables Filtering
19. Add All Fields to Query Editor, with or w/o alias
20. Thousands separator for numeric fields
21. Contextual Help / F1
22. Quick switch between Legacy and Standard SQL
23. Save Default SQL Version
24. Support for BigQuery Named Paramaters (@param)
25. Keyboard Shortcuts to view previous/next and first/last page
Some Details:
1. Control size of the Datasets Panel
Datasets and tables names tend to be verbose. Allowing users to tune width of Datasets Panel is just little good to have.
2. Hide/Show Datasets Panel
Most of your time you spend playing with Query itself. Saving your screen real estate by hiding Datasets panel is another good to have
3. Datasets Filtering
Some of our Projects consist of hundreds and hundreds of datasets with tens of thousands tables in them available to users across the business. Ability to filter visible datasets helps navigate and locate needed dataset
4. Datasets Count (Filtered/Total)
Just simple counts
5. Monetary Cost estimation based on processed bytes
Estimated cost added to the validator and is based on estimated processing bytes. As well as it is based on billing tier 1 pricing ($5 per TB currently)
6. Keywords Auto-Capitalization
“Auto-capitalization as you type” is added for GBQ Keywords. It is only html decoration so copy/paste of BQL still is as originally typed and not as it is shown.
To address this – Preserve Format (in context menu) is introduced. After format is preserved – decoration is preserved as actual text. So you can copy paste “well-formatted” text.
7. Comment/Uncomment Selection or Outside Selection
Ctrl+/ and Shift+Ctrl+/ respectively comments and uncomments selected lines
Ctrl+Alt+/ and Shift+Ctrl+Alt+/ respectively comment and uncomment lines outside selection
8. Support for Parametrized Query / Saved Query with Parameters
If you have you Saved Queries stored with parameters – now you can easily bulk set those parameters using Parameters Button.
Note: parameters in this tool defined after another internal Viant’s BigQuery centric Orchestration and Scheduling Tool called Magnus. Magnus is using following naming rule for parameters:
See More
Stats
Trends for BigQuery Mate:
Rank
User count
Category Rank
Rating
Download
HOW TO INSTALL BigQuery Mate FROM A CRX FILE
- Download BigQuery Mate CRX file
- NOTE: Sometimes the browser may block downloading / installing CRX file from outside the Chrome Web Store. If so, you may need to download the ZIP file instead
- In the URL bar, go to chrome://extensions
- Enable Developer mode
Ratings
USER REVIEWS (0)
No reviews