Data Dancer - Big Query Studio
Execute, analyze and model Big Query within Visual Studio Code
Features
Variables
- Simple and powerful variable handling
- Substitute datasets, variables or settings depending on environment
- Variable highlighting and intellisense
![Variable highlighting](https://github.com/Debefy/data-dancer-samples/blob/main/images/use-of-variables.png?raw=true)
Environments
- Switch effortlessly between your datasets or environments
- Colorize your environments. Prevent production disasters
![Color coding](https://github.com/Debefy/data-dancer-samples/blob/main/images/environment-colors.gif?raw=true)
Execute Sql
- Run selected text or the full .sql file.
- Output to Data Dancer result window inside Visual Studio Code
- Investigate results without leaving Visual Studio Code
- Shows actual billed cost
Analyze Sql
- Dry-run: Get cost estimation from Big Query before running it
Copy Sql
- Copies the selected sql into clipboard. Substituting variables on the fly.
- Enabling switch to Big Query Studio or other tools
Data Analysis
![Data types in header](https://github.com/Debefy/data-dancer-samples/blob/main/images/data-types-in-header.png?raw=true)
- Inspect element: Get view, table schema or routine source code and schema
![Inspect view 3](https://github.com/Debefy/data-dancer-samples/blob/main/images/inspect-view3.png?raw=true)
- Investigate returning schema
- Investigate returning raw json
![Schema and json](https://github.com/Debefy/data-dancer-samples/blob/main/images/schema-and-raw-json.gif?raw=true)
Job details
- Summary of total rows, billed and execution time in job overview
- Click to quickly navigate to Big Query job information
![Job insights](https://github.com/Debefy/data-dancer-samples/blob/main/images/job-insights.png?raw=true)
Rich Export
- Export full output from jobs that produced data can be exported up to 24 hours after execution
- Supports csv, tsv, xlsx, json and export to clipboard
![Export data](https://github.com/Debefy/data-dancer-samples/blob/main/images/export-data.gif?raw=true)
Other features
Job Cost Limit
- Maximum limit of job cost is by default set to 100MB. You can override this in Data Dancer settings.
- Numerics and floats aligned, culturally formatted and raw data available via hover or click-to-copy
![Data type formatting](https://github.com/Debefy/data-dancer-samples/blob/main/images/type-formatting.png?raw=true)
Clipboard Integration
- Copy data from Data Dancer's result window on mouse click
- Quickly paste your tabular result to excel
![Clipboard integration](https://github.com/Debefy/data-dancer-samples/blob/main/images/copy-to-clipboard.gif?raw=true)
Location travel
- You can quickly override current geo location to enjoy exeucteing queries around the world
![Clipboard integration](https://github.com/Debefy/data-dancer-samples/blob/main/images/click-to-set-location.png?raw=true)
|
Requirements
You need a Google Cloud Big Query Account
Data Dancer features and context are available in .sql language files
Getting started
Create environment file
Set up one or more environments using json files like Dev, Test & Prod
You can use the wizard to generate one: Command Palette -> Data Dancer/Generate Environment...
Create variables for your environment, like sources or settings
Samples available here:
https://github.com/Debefy/data-dancer-samples/tree/main/environments
Switch between environments
Right click your .json file and choose "Use as Data Dancer Environment"
or click Data Dancer heart icon at bottom right of Visual Studio Code
Feature history
0.2.1
- NEW: Added table and view list, with possibility to preview table data
- NEW: Arrays are indicated with brackets
0.2.0
- NEW: Command for running sql up to the point where the cursor is
- NEW: Setting controlling if clicking left mouse button automatically copies to clipboard
0.1.54
- NEW: Logo, updated readme
0.1.51
- NEW: Export improvements, export of complex types and structs. Export of repeated fields to json
0.1.36
- NEW: Link to job details - also available on job errors
- NEW: Sortable nested columns
- FIX: Do not timeout jobs since they are run until they end anyway
0.1.33
- Click location in right corner to override. Click again to clear or reset
0.1.32
- Inspect element in selected text: table, view or routine
0.1.31
- Menus and items following theme in VS Code
- Validation checks to find if required 'gcloud sdk' is installed
- Get started: Create environment using wizard
- Result paging
- Sortable columns
0.1.30
- Result window is moved to a tab at the bottom window
- Big query job links are clickable during execution
| |