SQL Workbench/J with Treasure Data

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. You can use SQL Workbench/J as SQL authoring tool to interactively develop SQL queries with Treasure Data.

Untitled-3
This article is using Mac OS 10.9.3 as an environment. So the screenshot may be a little bit different on Windows and Linux, but it works on both OSs as well.

Table of Contents

Step 1: Install

Please download the latest SQL Workbench/J installer from below, and install the application.

Please follow the instruction described in Installing and starting SQL Workbench/J page.

Untitled-3
SQL Workbench/J requires Java 7 or higher.

Step 2: Download Treasure Data JDBC Driver

Please download Treasure Data’s JDBC Driver from below.

Step 3: Add Treasure Data ODBC Driver

Select File at the top menu, and click Manage Drivers. Plese fill the forms like below.


  • Name: Treasure Data
  • Library: JDBC driver file path
  • Classname: com.treasuredata.jdbc.TreasureDataDriver
  • Sample URL
    • Hive: jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=hive
    • Presto: jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=presto

Step 4: Connect to Treasure Data

Select File at the top menu, and click Connect window. Please fill the forms like below.


  • Name: Whatever you like
  • Driver: Treasure Data
  • URL: jdbc:td://api.treasuredata.com/sample_db;useSSL=true
  • Username: Your account email
  • Password: Your account password
  • Read only: True

Then, please click OK to add the connection.

Step 5: Issue the Query

You’ll see a list of tables and its columns by GUI.


Move to the Statement pane, and fill in the SQL query to be thrown. Please hit Ctrl + Enter once the query is ready, then the query will run and it will show the results. You can check the progress of the query from Web console.



Last modified: Aug 21 2015 23:46:19 UTC

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