StarRocks

The StarRocks Tableau connector enables seamless and secure integration between Tableau and StarRocks. It provides efficient lakehouse query capabilities, empowering you to leverage Tableau's powerful visualization and analytics features. Version 2.1 supports a three-tier architecture of Catalog, Database, and Table, but it requires the corresponding driver to be used in conjunction. It also supports large-scale Exact.

Tableau Desktop

Prerequisites

Before proceeding, make sure the following requirements are met:

• Tableau Version: Tableau 2020.4 and later
• CelerData or StarRocks Version: v3.2 and later

Install Connector for Tableau Desktop

1. Download the StarRocks JDBC Driver.
2. Store the driver file in the following directory (create the directory if it does not exist):
   • macOS: ~/Library/Tableau/Drivers
   • Windows: C:\Program Files\Tableau\Drivers
3. Download the StarRocks Tableau JDBC Connector (taco) file using the **Download** button at the top of the page.
4. Store the connector file in the following directory:
   • macOS: ~/Documents/My Tableau Repository/Connectors
   • Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
5. Launch Tableau Desktop.
6. Navigate to Connect -> To a Server -> StarRocks JDBC by CelerData.

Install Connector for Tableau Server

• Download the StarRocks JDBC Driver.

• Store the driver file in the following directory (create the directory if it does not exist):

  • Linux: /opt/tableau/tableau_driver/jdbc
  • Windows: C:\Program Files\Tableau\Drivers

  On Linux, you must permit the "Tableau" user to access the directory. Follow these steps:

Create the directory and copy the driver file to the directory:

```bash
sudo mkdir -p /opt/tableau/tableau_driver/jdbc

# Replace <path_to_driver_file_name> with the absolute path of the driver file.
sudo cp /<path_to_driver_file_name>.jar /opt/tableau/tableau_driver/jdbc
```

Grant permission to the the "Tableau" user.

```bash
# Replace <driver_file_name> with the name of the driver file.

sudo chmod 755 /opt/tableau/tableau_driver/jdbc/<driver_file_name>.jar
```

1. Download the StarRocks Tableau JDBC Connector (taco) file using the **Download** button at the top of the page.

2. Store the connector file in the following directory of each node:

   • Linux: /opt/tableau/connectors
   • Windows: C:\Program Files\Tableau\Connectors

3. Restart Tableau Server.

   tsm restart
   

   Note

   You must restart Tableau Server to apply the changes whenever you add, remove, or update a connector.