This page describes how to set up Tableau Desktop and configure it for use with Rockset.
The steps below require that you have a Rockset account and have the Rockset Java SDK jar version 0.7.0+. For instructions on building the jar, refer here. You can also download the jar (rockset-java-\$version.jar) from Maven.
Note: Make sure your Tableau Desktop installation is version 2019.2 (or later) and you have Rockset Java SDK version 0.7.0 (or later).
- Create an API Key using the Rockset Console under Manage > API Keys.
Place the Rockset Java SDK jar in the following folder depending on the operating system:
- Windows: C:\Program Files\Tableau\Drivers
- Mac: ~/Library/Tableau/Drivers
Refer to Tableau Documentation for more detailed instructions.
In Tableau, navigate to Connect To a Server and select
Other Databases (JDBC):
- Configure the connection as follows:
apikeyas Username and Rockset API Key as the password.
- Click on
Explore the schema of all Rockset collections present in your workspace:
#Publishing to Tableau Server
Publish a workbook along with a data source to your Tableau server:
Serverin the Menu.
- Edit Data Sources and select
Embedded passwordfor Authentication.