Odbc Driver for Presto

Copy

• Copy for LLM

  Copy page as Markdown for LLMs
• View as Markdown

  Open this page as Markdown
• Open in ChatGPT

  Get insights from ChatGPT
• Open in Claude

  Get insights from Claude
• Connect to Cursor

  Install MCP server on Cursor
• Connect to VS Code

  Install MCP server on VS Code

Treasure Data provides a Presto API that can integrate directly with our Presto-specific ODBC driver. The installer for the driver is currently available for Windows 64-bit platform only.

• Release Downloads
• Windows System Requirements
• Migrate from Treasure Data ODBC Driver for 32bit
• Install the Driver on Windows (64-bit)
• Configure the Proxy Server

Release Downloads

The downloads are available from your account or support representative.

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

• 2020-06-16 Download __ 1.4.0 – you must select Download.

  • Support for two-way authentication

  • Support for Open-source Presto Server versions 0.235 and earlier

  • Support Presto Foundation Server 333 and earlier

  • The driver requires TLS version 1.2

  • Installer ships with visual c++ 14 runtime libraries (x64)

• 2018-06-19 Download 1.3.0

Windows System Requirements

One of the following operating systems:

• Windows Vista, 7, 8, or 10

• Windows Server 2008 or later

• Visual C++ Redistributable Packages for Visual Studio 2013 installed. You can download the installation packages at https://www.microsoft.com/en-ca/download/details.aspx?id=40784.

Migrate from Treasure Data ODBC Driver for 32bit

Treasure Data ODBC Driver for 32bit is no longer supported. Replace it with Presto ODBC Driver according to the following instructions. The old driver is no longer supported.

Install the Driver on Windows (64-bit)

1. Download the ODBC driver installer TreasureDataPrestoODBC.msi.

2. Double-click on the installer package and follow the 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 select Configure.

5. Enter your Master TD API key into the User field.
   Follow these instructions to obtain your Master TD API key.

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

7. Select Test.

8. If successful, press OK.

Configure the Proxy Server

If you are connecting to a data source through a proxy server, you must provide connection information for the proxy server.

1. Open the ODBC Data Source Administrator where you created the DSN. Select the DSN, select Configure , and then select Proxy Options.

2. Check the Use Proxy Server box.

3. In the Proxy Host field, enter the hostname or IP address of the proxy server.

4. In the Proxy Port field, enter the TCP port number that the proxy server uses to listen for client connections.

5. In the Proxy Username field, enter your user name for accessing the proxy server.

6. In the Proxy Password field, enter the password of the user name.

7. (Optional) To save the proxy server in the Windows registry, select Save Password (Encrypted).

8. Click OK.