Setup

Install Presto ODBC Connection

Set up ODBC Connection

Firstly, select "Other Databases (ODBC)" on the left menu. Then choose Treasure Data Presto ODBC DSN that has been set up in Presto ODBC Connection and push "Connect". Note that no input is required in Connection Attributes.

After that, "Sign In" button appears. Pushing the button, then Database connection page will show up. By choosing schema (database) and table, you will be able to access the table data.

Tips and Tricks

Convert time Field as Datetime Type

Treasure Data treats time column as unix timestamp by default, however 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 Creat Calculated Field...

Then, enter the name and enter the following function within Formula section.

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

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

Contact Us

If you are you interested in using Treasure Data with Tableau, contact your account representative.