Visit our new documentation site! This documentation page is no longer updated.

Presto ODBC Connection

We provide a Presto API that can integrate directly with our Presto-specific ODBC driver. The installer for the driver is currently available only for Windows 64-bit platforms.

Table of Contents

Downloads

  • TreasureDataPrestoODBC.msi
    • Windows Treasure Data Presto ODBC Driver installer
  • Treasure Data Presto ODBC Driver.tdc
    • Tableau Datasource Customization File (.tdc) for Tableau users.
    • Copy this file to My Documents\My Tableau Repositories\Data Sources folder.
      • This file controls Tableau to use Presto compatible SQL queries.

Release Notes

  • 2017-09-15 Fixes TDC file to avoid an issue when unicode characters are used in column aliases.
  • 2017-08-22 Updated Tableau TDC file. Overwriting existing TDC file is recommended for every Tableau users to suppress unnecessary queries.
  • 2017-08-21 Applied a hot fix to support long prepared statements (No ODBC driver upgrade is required).
  • 2017-05-31 1.2
    • Fixed a bug when custom installation path is used.
  • 2017-05-12 1.1 (Support Presto ~ 0.175 or later)
  • 2016-10-14 1.0 (Support Presto ~ 0.153. This version will no longer work after May 2017, and will be deprecated on June 6, 2017)

Windows System Requirements

One of the following operating systems:

Migration from Treasure Data ODBC Driver for 32bit

Treasure Data ODBC Driver for 32bit is no longer supported. Please replace it with Presto ODBC Driver according to the instruction below. Old driver will be no longer work from June 6, 2017.

Installing the Driver on Windows (64-bit)

  1. Download the ODBC driver installer TreasureDataPrestoODBC.msi
  2. Double click on the installer package and follow the on-screen instructions
  3. Open the Start menu (or press the Windows key) and search/select ‘ODBC Data Source Administrator (64-bit)’
  4. Select Treasure Data Presto ODBC DSN, and press Configure button:

ODBC Data Source Administrator (64-bit) 5. Enter your Master TD API key into the User field (please follow these instructions to obtain your Master TD API key)


ODBC Data Source Administrator (64-bit)

  • Authentication Type: No Authentication
  • User: YOUR MASTER API KEY
  • Host: https://api-presto.treasuredata.com
  • Port: 443
  • Catalog: td-presto

  • Click Test button and if successful, press OK

Using Presto ODBC with Tableau Desktop

Upon completion of all the above steps, please use the following steps to connect Tableau Desktop to TD:

  1. Download the Treasure Data Presto ODBC Driver.tdc file into your Tableau installation folder. By default it’s in My Documents\My Tableau Repositories\Data Sources.
  2. Open Tableau Desktop and choose Other Databases (ODBC):

Tableau_TD_1 3. Connect using DSN and choose Treasure Data Presto ODBC DSN. Click Connect; a connection request will be processed. There will be no prompt. Just click on Sign In.


Tableau_TD_2 4. A new book will open with Treasure Data as a connection. Choose, td-presto in the Database dropdown:


Tableau_TD_3 5. A new drop down, Schema, will appear. This refers to a database in Treasure Data. Provide a name and search (press Enter or click Search icon) or just search and choose from the list:


Tableau_TD_4 6. A new drop down, Table, will appear. This refers to a table in the schema chosen above. Provide a name and search (press Enter or click Search icon) or just search to see the list of available tables:


Tableau_TD_5 7. Drag a table to the area on the right to see the table structure:


Tableau_TD_6 8. Now, you can open a new sheet and use the new table to create charts:


Tableau_TD_7

Migration Guide for Treasure Data ODBC Driver

If you have already used Treasure Data ODBC Driver for Tableau / Excel, please refer to this guide. You can migrate your existing Tableau / Excel ODBC Connections.

If you have any questions, please email us at support team.


Last modified: Oct 26 2017 22:49:06 UTC

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