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 visualisation and analytics features.

Version 2.0 supports a three-tier architecture of Catalog, Database and Table, but it requires the corresponding driver to be used in conjunction.

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 Catalog 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 Catalog 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:

  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 ‘Tableau’ user.

  # 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.