How do I visualize a customized dataset in my BI Tool?
Spotlight serves as a bridge between your analytics tool and the various data sources that are supplying information to a Spotlight dataset. When you run a query in your analytics tool, that query is being distributed by Spotlight to the relevant data source systems and the live results are returned to you.
To open a Spotlight dataset in an external analysis tool:
- Visit the dataset's detail page or select it while in a Workspaces's Workbench
- Click the button in the top right corner that corresponds to the tool you wish to open.
- Tableau. When one uses the button on a dataset the browser starts downloading a TDS file. Open this file in a licensed copy of Tableau Desktop and a live connection will be automatically setup.
- Jupyter. When one uses the button on a dataset, the browser starts downloading a py file. Save this file to a directory on a local machine and edit it in a text editor to add appropriate user credentials and the location of the Simba driver. Run jupyter-notebook in the same directory containing the downloaded py file and begin accessing your Spotlight dataset via Jupyter Notebooks. Note! Connecting to Spotlight from Jupyter Notebooks requires a Spark JDBC driver and various python ODBC support libraries.
If you encounter any permission errors in your analytics tool, log in to Spotlight and make sure you can view the contents of the dataset there. Enter any missing credentials for specific data sources or update them if your credentials have changed on the source system.
Please refer to the External Tools section of Spotlight documentation for more details.