This section details how to connect to Pinot from Tableau using JDBC
Tableau is a popular data visualization tool for enterprise business intelligence. In this section we'll cover the details on how to use Pinot's JDBC client to connect and query real-time or offline tables from Tableau Desktop.
As a part of the Pinot open source distribution, we provide a JDBC client that must be built from source code and is not yet available as a binary. We plan to expand support for the JDBC client as a binary in the near future. In this section, we'll walk through building the Pinot project from source and locating the binaries required to connect to Pinot from Tableau Desktop.
The first step is to clone Apache Pinot from GitHub, which will pull down the most recent Pinot snapshot from the git repository. From your terminal, clone the official Apache Pinot repository to your local disk.
After you clone the Pinot source using git, you will need to build the project using Apache Maven.
To build the Java binaries of Apache Pinot, you must have JDK 11+ installed and the latest version of Apache Maven.
Now, from your terminal, change directories to the top-level folder containing the cloned Apache Pinot source code. Now, run the following command to build Pinot from source.
If you have the correct prerequisites installed, the build will complete successfully in 5-10 minutes, depending on your machine's resources. When the build is complete, Maven will have installed the necessary binaries on your local machine.
Your local machine has a Maven repository, called m2, which contains a cache of Java binaries, either built from source or cloned from a hosted Maven repository. To locate this directory, run the following command in your terminal, which will locate the m2 repository on your machine.
After running this command, you should see something similar to the following output.
On line 10 of the above output, you will see an example folder location of the local Maven repository for a macOS user. The folder location we'll use for this guide will be /Users/user/.m2/repository.
The folder location for your Maven repository will be different for Windows users, but the binaries and folder structure of the m2 repository are the same on both operating systems.
There are three binaries that are required by Tableau to be able to connect to Pinot. Each of these binaries are located inside the m2 repository on the machine that you used to build Pinot from source. After completing the previous step, you will need to locate those binaries using the folder location of your m2 repository, such as /Users/user/.m2/repository for this example.
The directory we need to copy the binaries to will depend on your operating system. Your Tableau Desktop installation will create a Drivers directory, which will vary depending on whether you are using macOS or Windows. The folder locations for each operating system are listed below.
macOS: ~/Library/Tableau/Drivers
Windows: C:\Program Files\Tableau\Drivers
In the previous section, we located the Driver directory for your Tableau Desktop installation on macOS. Now, let's now copy the three Pinot binaries from their respective m2 repository locations to Tableau's Drivers directory. The output from the command below will identify and save the most recent Pinot snapshot version that you've installed from Maven to an environment variable.
To check to make sure that Pinot was correctly installed on your machine using Maven, run the following command.
The output of the command should be something like the following: #.#.#-SNAPSHOT. If that's the case, then you can run the following commands in the same terminal window to install the Pinot binaries to Tableau Desktop.
Now, verify that the three binaries are present in your Drivers directory.
If the output from the command on the first line of the previous snippet matches the three JAR files listed on lines 3 and 4 in the above output, then you've successfully installed the Pinot connector for Tableau Desktop.
This section is coming soon. Please refer to the previous section and substitute the Windows directories using the same process.
Now that you've installed the Pinot JDBC connector binaries to your Tableau Desktop installation, you can begin to use Pinot as a data source. On your machine, make sure you restart Tableau so that it can locate and use the Pinot JDBC connector files that we copied to the Drivers directory in the previous steps.
Once Tableau Desktop has restarted, you can now create a new JDBC connection to Pinot using the following steps.
Create a new Tableau Book using the File > New menu option
In the new Book, use the Data > New Data Source menu option
Locate the Other Databases (JDBC) option in the resulting window
Add your Pinot JDBC connection URL (jdbc:pinot://localhost:9000)
Choose SQL92 as your dialect
Click Sign In
The result of the previous steps should result in a successful connection to Pinot. If the connection fails, make sure that you note the resulting error message. If the connection to Pinot could not be established, it is likely that you do not have network access to either the Pinot controller or broker from your machine. For Tableau to be able to query Pinot, you'll need to make sure that both the controller (by default localhost:9000) and the broker (by default localhost:8000) can be accessed from your machine.
For any other error messages or connection issues, please contact us on our community Slack and report your issue on the Troubleshooting channel.
The Pinot Connector for Tableau is currently available using the steps listed in this guide. In the future, we plan to make this much easier by allowing you to connect to Pinot using a JDBC driver available directly from your Tableau Desktop installation. Please continue to check back here in the following months to see our progress. You can also help us by requesting Pinot as an embedded data source from Tableau support.