Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Using Tableau Desktop with Arm Treasure Data enables you to interactively explore huge amounts of data. You can also use Treasure Data as a place to integrate and store all your data.


Table of Contents

Make the Connection

Start Tableau. Click Connect > Presto.

For a complete list of data connections, click To a Server > More.

Image Added

Then complete the following steps:

  1. Enter Presto JDBC/ODBC Gateway server: api-presto.treasuredata.com

  2. Enter the port: 443

  3. Enter the catalog name; td-presto

  4. Select the Authentication method: Username

  5. Enter the Username: Use your master APIKEY (Ref. Get APIKEY

  6. Select the Require SSL check box.

  7. Select Sign In.

Image Added


If Tableau cannot complete the connection, verify that your credentials are correct.

Connect to TD Presto Endpoint

...

Enter a Schema (database name) and Table (table name) to import data from a table, or to write SQL that imports data from multiple tables. Select Update Now to see the data in the Tableau window.

Image Modified


Confirm Import in Treasure Data

...

Treasure Data treats the time column as a UNIX timestamp by default, however, it’s really convenient to handle timestamp with Datetime type in Tableau. The following example describes how to create the calculated Datetime field for the “time” column.

Image Modified


Select Create Calculated Field.

Image Modified


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

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

Image Modified


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

Image Modified