Tableau

Tableau is a visual analytics platform from Salesforce for data visualization, interactive dashboarding, and KPI scorecards.

Tableau desktop connector

Tableau offers impressive connectivity that lets you visualize data from a wide range of sources. Besides dozens of built-in connectors and partner-built connectors (available on Tableau Exchange), Tableau also gives the tools to build a customised connector using the Tableau connector SDK.

Prerequisites

1. Check OS requirement: Currently Tableau Desktop only supports Windows and macOS.

📘

Suggested environment config

Windows

• Microsoft Windows 8/8.1, Windows 10 (x64)
  
• 2 GB memory
  
• minimum 1.5 GB free disk space
  
• CPU must support SSE4.2 and POPCNT instruction sets
  

mac

• macOS Mojave 10.14 / macOS Catalina 10.15 / macOS Big Sur 11.4+ / macOS Monterey 12.6+ (for Tableau 2022.3+)
  
• Intel processor / M1 processors under Rosetta 2 emulation mode
  
• minimum 1.5 GB free disk space
  
• CPU must support SSE4.2 and POPCNT instruction sets

2. Download desktop version from the Tableau website.
3. When installation is finished, mark the installation folder e.g.
   /Applications/Tableau\ Desktop\ 2021.3.app/Contents/MacOS/Tableau

Using Tableau with ByteHouse connector

Step 1. Download the JDBC driver

Download latest JDBC driver
Version 1.1.0 or higher
Jar extension: -all.jar

Step 2. JDBC jar location

Move the JDBC jar to this location

/Users/$your_user_name/Library/Tableau/Drivers

Step 3. Download connector plugin

• Download connector plugin from this repository (bytehouse-connector folder)
  
• File name: "bytehouse_jdbc.taco"
  

https://code.byted.org/bytehouse/bytehouse-tableau-connector/tree/master/files

Move the connector plugin to this location

/Users/$YOUR_USER_NAME/Documents/My_Tableau/Connectors

Step 4. Run using Tableau desktop

/Applications/Tableau\ Desktop\ 2021.3.app/Contents/MacOS/Tableau -DConnectPluginsPath=/Users/$YOUR_USER_NAME/Documents/My_Tableau/Connectors

Tableau desktop version required: 2021.3 or higher

📘

Windows users can follow Tableau official docs with the above mentioned files: https://tableau.github.io/connector-plugin-sdk/docs/run-taco

📘

For storing the connector file (taco file / connector folder), please don't create a directory where there are spaces in the name of the directory. For example, "/Users/$YOUR_USER_NAME/Documents/My Tableau Repository/Connectors" may not work because of the spaces in "My Tableau Repository". Instead you can use "My_Tableau_Repository".

Step 5. Connect ByteHouse via JDBC

Choose "ByteHouse JDBC by ByteDance" from the available connectors

Step 6. Connect Bytehouse

Fill up the account credentials in ByteHouse connector UI and sign-in

Step 7. Demo of Tableau integration with ByteHouse

Dataset exploration
Dataset contains COVID-19 confirmed cases and deaths based on region, country, date, etc. Dataset can be downloaded from here.

Dataset ingestion
Dataset can be ingested to ByteHouse using "data-import" through CSV file. Alternatively, data can also be ingested using bytehouse-cli.

--create database
CREATE DATABASE neuron_poc;

--create table
CREATE TABLE neuron_poc.covid_cases
(
        Case_Type String,
        People_Total_Tested_Count Integer,
        Cases Integer,
        Difference Integer,
        Date Date,
        Combined_Key String,
        Country_Region String,
        Province_State String,
        Admin2 String,
        iso2 String,
        iso3 String,
        FIPS String,
        Lat Double,
        Long Double,
        Population_Count Integer,
        People_Hospitalized_Cumulative_Count Integer,
        Data_Source String,
        Prep_Flow_Runtime Datetime
)
ENGINE = CnchMergeTree()
ORDER BY tuple()

For data import, please upload data by creating data loading job and load data from where the source is

Once data is loaded successfully, please login and connect to Tableau via Step 4 ~ 6

Dataset view in Tableau:

Covid-19 visualization with ByteHouse