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
- 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
- Download desktop version from the Tableau website.
- 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
Updated 2 months ago