Data viz extension for SQL Server Management Studio.
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 is a super cool and useful tool for interactively exploring large amounts of data.
See more on YouTube
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:
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:
