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

SQuirreL SQL with Treasure Data

SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database. You can use SQuirrelSQL as SQL authoring tool to interactively develop SQL queries with Treasure Data.

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 SQuirreL SQL installer as jar file below.

After you execute the jar file, the installer should start. Please proceed by clicking Next buttons.

Only Standard pack is required for Treasure Data.

Once the installation is done, please launch SQuirreL SQL.

Step 2: Download Treasure Data JDBC Driver

Please download Treasure Data’s JDBC Driver from below.

Then please put this driver to SQuirreL SQL’s driver directory.

$ mv td-jdbc-0.2.10-jar-with-dependencies.jar /Applications/
The target directory is $SQUIRREL_SQL_INSTALL_PATH/lib/ on Windows and Linux.

Step 3: Add Treasure Data JDBC Driver

Please click Drivers at the left pane, and hit plus button to add a new driver.

Please fill the information like below.

  • Name: Treasure Data
  • Example URL:
    • Hive: jdbc:td://< database >;useSSL=true;type=hive
    • Presto: jdbc:td://< database >;useSSL=true;type=presto
  • Java Class Path: td-jdbc-xxx.jar
  • Class Name: com.treasuredata.jdbc.TreasureDataDriver

Step 4: Connect to Treasure Data

Finally, please click Aliases tab at the left pane and click plus button to add the Alias.

  • Name: Whatever you like
  • Driver: Treasure Data
  • URL: jdbc:td://< YOUR_DATABASE_NAME >;useSSL=true
  • User Name: Your account email
  • Password: Your account password

Please click Test once the forms get filled. If the information is correct, it will say Connection successful.

Please click OK once it’s ready.

Step 5: Issue the Query

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

Move to the SQL 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, let us know. For all other issues, access our support channels.