Connecting Excel to SNAP

SNAP can be accessed using standard B.I tools and Excel is one of the most widely used tools for analysis, Pivots and much more.

To connect Excel simply use an ODBC Driver for Spark such as from Simba. On a mac you can setup a user DSN as follows

 

To connect to SNAP you can use the Simba ODBC Spark Driver. Since SNAP is powered by Spark, you would use Spark SQL against SNAP Indices.

You can return the data into the sheet and Pivot on the dataset

With Excel, Tableau and similar B.I tools connecting directly to live multi-billion row datasets with low latency, Analysis and B.I on Big Data is now open to everyone in the organization.

 


sparklinedata

Comments are closed.