Using Tableau Desktop with 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.
Make the Connection
Start Tableau. Click Connect > Presto.
For a complete list of data connections, click To a Server > More.
Then complete the following steps:
Enter Presto JDBC/ODBC Gateway server: api-presto.treasuredata.com
Enter the port: 443
Enter the catalog name; td-presto
Select the Authentication method: Username
Enter the Username: Use your master APIKEY (Ref. Get APIKEY
Select the Require SSL check box.
Select Sign In.
If Tableau cannot complete the connection, verify that your credentials are correct.
Connect to TD Presto Endpoint
Select More on the left menu. Choose Presto and enter the connection information. Select Sign In.
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.
Confirm Import in Treasure Data
In Treasure Data, create a query to track the events coming in from Tableau Desktop. It usually takes 3-5 minutes before events appear in the TD Console.
Tips and Tricks
Convert Time Field as Datetime Type
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.
Select Create Calculated Field.
Then, enter the name and enter the following function within Formula section.
sql RAWSQL_DATETIME("from_unixtime(%1)", [time])
Next, the calculated field appears in a list of Dimensions, with a Datetime type.