Motivation
Write a query, run it, and see the results on the fly in VSCode, much like BigQuery web UI.
Installation
BigQuery Runner - Visual Studio Marketplace
Features
Query Validation
You can write queries while checking the queries you are writing for syntax errors, unrecognized field names, etc.
Because the extension marks error locations on the editor file.
Query Costs
You need not be overly concerned about how much data the query you are writing will scan and charge for.
Because the extension will show you the amount of data that would be scanned and the amount of data actually scanned.
Running Query
You can query the file you have open directly into a BigQuery, or if you have selected text, you can query that text.
Format Results
Output formats supported include aligned tables, CSV, JSON, and JSON Lines.
Output Results
You can view the results of your query in a dedicated panel, in the output panel, or even output them to a file.
Command Based
You can execute all operations from commands.
Command support means that once you have set your key bindings, you can repeatedly try queries without taking your hands off the keyboard.
Top comments (0)