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
Environments
- Switch effortlessly between your datasets or environments
- Colorize your environments. Prevent production disasters
dbt (experimental)
- Resolve
{{ ref('model_name') }} tags to fully-qualified identifiers using dbt_project.yml and profiles.yml
- Dataset naming uses the profile output dataset and appends the configured model schema suffix (from
schema or +schema) when present
- If no schema is configured for a model folder, the dataset remains the base dataset from the profile output
Example:
models:
my_project:
srv:
+schema: "srv"
Resolves the dataset as <profile_dataset>_srv for models under srv, while other folders without schema keep <profile_dataset>.
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
- Inspect element: Get view, table schema or routine source code and schema
- Investigate returning schema
- Investigate returning raw json
Job details
- Summary of total rows, billed and execution time in job overview
- Click to quickly navigate to Big Query job information
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
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
- Footer summaries: toggle Σ/a/d/c with tooltips, distinct counts, and compact checksums across columns
Clipboard Integration
- Copy data from Data Dancer's result window on mouse click
- Quickly paste your tabular result to excel
Location travel
- You can quickly override current geo location to enjoy exeucteing queries around the world
|
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
Release Notes
Data Dancer uses two release channels:
- Stable: Production-ready releases (default for all users)
- Preview: Early access to new features (opt-in for testing)
To try preview features, go to Data Dancer in VS Code Extensions and click "Switch to Pre-Release Version".
For detailed release notes and feature history, see the changelog on VS Code Marketplace.
You can also view the changelog by opening the Command Palette (Ctrl+Shift+P / Cmd+Shift+P) and running:
Data Dancer: Show Changelog
Contributing
See RELEASE_PROCESS.md for information about how preview and stable releases work.
License
This extension is distributed with the following documents inside the installed extension package:
