Skip to content
| Marketplace
Sign in
Visual Studio Code>Other>Data DancerNew to Visual Studio Code? Get it now.
Data Dancer

Data Dancer

Preview

Debefy

|
130 installs
| (0) | Free
BigQuery Perfect Pitch. Model, Maintain and Analyze your BigQuery solutions with ease
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Data Dancer - Big Query Studio

Data Dancer Logo

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

Environments

  • Switch effortlessly between your datasets or environments
  • Colorize your environments. Prevent production disasters

Color coding

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

  • Quick data type insights

Data types in header

  • Inspect element: Get view, table schema or routine source code and schema

Inspect view 2 Inspect view 3

  • Investigate returning schema
  • Investigate returning raw json

Schema and json

Job details

  • Summary of total rows, billed and execution time in job overview
  • Click to quickly navigate to Big Query job information

Job insights

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

Other features

Job Cost Limit

  • Maximum limit of job cost is by default set to 100MB. You can override this in Data Dancer settings.

Type formatting

  • Numerics and floats aligned, culturally formatted and raw data available via hover or click-to-copy

Data type formatting

Clipboard Integration

  • Copy data from Data Dancer's result window on mouse click
  • Quickly paste your tabular result to excel

Clipboard integration

Location travel

  • You can quickly override current geo location to enjoy exeucteing queries around the world

Clipboard integration
Clipboard integration |

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.6

  • NEW: Bottom panel. Added tabs for cleaning GUI

0.2.5

  • NEW: Project explorer. Copy full id of dataset, table, view or routine to clipboard
  • FIX: Project explorer. Improved handling of configured additional projects
  • FIX: Project explorer. Fixed bug when refreshing list of tables, view and routines
  • FIX: Open editors. Removed this feature

0.2.4

  • NEW: Added possibility to add additional project ids appearing in the activity bar

0.2.3

  • NEW: Added "SELECT shallow" and "SELECT deep" to object of inspection
  • NEW: Added "Generate definition" to object of inspection
  • NEW: Added "Preview data" to object of inspection

0.2.2

  • NEW: Added generate shallow and deep select statements

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
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft