DEV Community

Daisuke Mino
Daisuke Mino

Posted on • Edited on

BigQuery Runner for VSCode

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 Validation

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.

Query Costs

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.

Running Query

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.

Image description

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.

Command Based

Top comments (0)