Skip to content

Data viz extension for SQL Server Management Studio

License

Notifications You must be signed in to change notification settings

martinnormark/DataDive

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

💦DataDive

Data viz extension for SQL Server Management Studio.

Status [hacks 💬]

This add-in was hacked together in a few evenings. It is very ugly written, with a ton of extensibility "hacks" still left around in the code. Run at your own risk!

Facets Dive from Google PAIR

Facets Dive is a super cool and useful tool for interactively exploring large amounts of data.

See more on YouTube

SSMS add-in

I've used Facets many times and I find it very useful to help me understand the data I'm querying from a SQL database.

The results table doesn't give you a very good idea, if any, about how lots of rows are distributed per column, if you have a lot of NULL values or how the relationship between columns are.

While it is easy enough to export a result set as CSV, go to the Facets page and load it — it would be much nicer to have it inside of management studio...

Which is what you can do with this add-in — you simply query your data as you always do, and then click `View in Facets" from the Tools menu and your result set is automatically displayed:

img

Installation

Download the latest DataDive.exe from the releases.

This is a self-extracting archive. Extract it to C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions - the archive contains the DataDive folder.

It should look like this after correct installation: installed