# Tableau Desktop For Windows Import Integration

Using [Tableau Desktop](http://www.tableausoftware.com/) with Treasure Data enables you to interactively explore huge amounts of data. You can also use Treasure Data as a place to integrate as a data source.

## Make the Connection

Start Tableau. Select Connect > Presto or Trino.

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

![](/assets/image-20191016-205201.47f78f29ba2c1cfb09ca5eaa00d6656f47b946a4bbb520b845683154898594f9.d787083f.png)

Then complete the following steps:

1. Enter Presto JDBC Gateway server: [api-presto.treasuredata.com](http://api-presto.treasuredata.com)
2. Enter the port: 443
3. Enter the catalog name; td
4. Select the Authentication method: Username
5. Enter the Username: Use your master APIKEY (Ref. [Get APIKEY](https://docs.treasuredata.com/smart/project-product-documentation/accessing-rest-apis))
6. Select the Require SSL check box.
7. Select Sign In.


![](/assets/image-20191016-205302.1415e376909e9a12b7fa0d94b40da7a5246ef8c8dfc30479052cc7f34f4b7a37.d787083f.png)

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.

![](/assets/image-20191016-205528.7e05b6255431eb997e10d8b834ae58e9c0091041415258c7928090c34b047175.d787083f.png)

![](/assets/image-20191016-205538.a2ba5c768f566949756865f02a1d18a5c5e997f22f9bd0f03d68735460b2022f.d787083f.png)

## 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.

![](/assets/image-20191016-205551.8cce1a3b64201a1dbb7f41bad0b82919f720b7da0e9bb2e60d300cec57901b62.d787083f.png)

Select **Create Calculated Field.**

![](/assets/image-20191016-205608.119241d8292235af4ffba81efb0870f48bfa1ffc42c37cc1987304ee677a271c.d787083f.png)

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

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

![](/assets/image-20191016-205626.cce639ac294facb89c32b939438394d113eb2141bb591fc45a0b6e5e32a8d42c.d787083f.png)

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

![](/assets/image-20191016-205651.543ecc66240074c0a6cb0dc8c5a9717c9e36bd9838ec19edd38170f02b2300cf.d787083f.png)