Introducing the Altinity Tableau Connector for ClickHouse

This blog article gives you all the information necessary to get started with the new connector using Tableau Desktop. We hope Tableau fans will try it out and provide feedback. Let’s dive in!

The second is via the Altinity ClickHouse Tableau Connector. The connector provides metadata that enables Tableau to translate native queries properly to ClickHouse SQL. With the connector, Tableau visualization features can be correctly implemented in ClickHouse.

The following diagram shows the two connectivity pathways.

Note that the ClickHouse Connector still depends on the ClickHouse ODBC driver. To use the new Connector we’ll need to install both of them.

We have verified the connector using Tableau Desktop. The installation includes the following steps:

“c:\Program Files\Tableau\Tableau 2021.2\bin\tableau.exe” -DConnectPluginsPath=C:\Users\someuser\Documents\TableauConnectors

You will see a display similar to this image once Tableau starts.

To access data, we’ll need to select the ClickHouse Connector and login. If you are just starting out you’ll need to click on More…, which will expand into a list of connectors. Locate the ClickHouse by Altinity Inc entry and click on it. You’ll be invited to enter the location and login of your ClickHouse server.

Click Sign In to complete login. You’ll see a screen like the following.

We are now ready to start exploring data on ClickHouse.

Let’s start with a simple display of airline ontime data that shows flights by year and by airline carrier. First we need to select a table for queries. Drag the ontime data over to the Drag tables here panel. The display looks like the following:

Next, press Sheet1 at the bottom of your screen. This will display a new sheet with the table columns on the left hand side, and the visualizations available on the right. Follow the steps shown below to construct a chart.

After completing these steps you will have a nice chart that looks like this.

That’s it! You can now start to try out many other types of visualizations on ClickHouse data using Tableau.

Speaking of problems…There are a couple that we know about already, so here they are in case you meet them.

Related posts:

What is the InterPlanetary Federation? Born out of troubling times in the Alien Worlds galaxy, the IPF is a proposed solution to unite qualified Custodians from participating Syndicates into a…

Inflation is an economic term used to describe rising prices of goods and services in an economy. Put simply, this means that there is a higher cost of living. Typical examples in Pakistan would…

Jill Biden and Bernard Tyson share the stage with hundreds of health innovators as they recommit to achieving audacious health moonshots.