Tableau Desktop with Treasure Data

Using Tableau Desktop with Treasure Data allows users to interactively explore huge amounts of data.

Untitled-3
We have a new ODBC driver for working with Tableau Desktop! Please reach out to support@treasure-data.com to get set-up. The following driver & instructions are no longer actively supported.

Table of Contents

Prerequisites

  • Windows 7, 8.1, or later
  • Tableau Desktop 8.2 (32-bit application)

Install ODBC Driver

Please install Treasure Data ODBC Driver, and register to your machine. We’ll assume you have DSN (Data Source Name) as Treasure Data in the following sections.

Establish ODBC Connection

Start Tableau and Select Driver

Please launch Tableau, and select Connect to Data first.

StartTableau

Please select Other Databases (ODBC) from the left menu, and select Treasure Data (or your own DSNNAME) in Connect Using section.

OtherDatabases

Please fill in Connection Attributes as well like followings, and click OK.

EditConnection

  • DSN: Treasure Data (Your DSN name)
  • Server: pggw.treasuredata.com
  • Port: 5439
  • Database: public
  • Username: YOUR_EMAIL
  • Password: YOUR_PASSWORD

Select table and database on TreasureData

Please remain Database as Public, and select the database name in Treasure Data at Schema section. We know it’s a bit confusing :(

Set database

Next, please select the table name in Treasure Data, and click Go to Worksheet.

Set Table

Finally, you can directly connect to Treasure Data via Tableau.

TableauWindow

Tips and Tricks

Convert time Field as Datetime Type

Treasure Data treats time column as unix timestamp by default, howevery it’s really convenient to handle timestamp with Datetime type on Tableau. To make the things easy, this section describes how to create the calculated Datetime field for “time” column.

select time

Select Creat Calculated Field...

select calc field

Then, please put the name, put the following function within Formula section.

sql RAWSQL_DATETIME("from_unixtime(%1)", [time])

set calc field

After that, the calculated field appiers in a list of Dimensions, with Datetime type.

Set t

Contact Us

Are you interested in using Treasure Data with Tableau? Please fill in the form to consult our technical staffs.


Last modified: Oct 15 2014 18:58:30 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.