SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database. You can use SQuirrelSQL as AN SQL authoring tool to interactively develop SQL queries with Treasure Data.
|Images in this article were created in the Mac OS 10.9.3 as an environment. The screens might look slightly different on Windows and Linux.|
Step 1: Install SQuirrel
Download the latest SQuirreL SQL installer as jar file:
After you execute the jar file, the installer starts. Click
Next to proceed through the installation.
Standard pack is required for Treasure Data.
When the installation is complete, launch SQuirreL SQL.
Step 2: Download Treasure Data JDBC Driver
Download Treasure Data’s JDBC Driver:
Then, put the driver into the SQuirreL SQL’s driver directory.
$ mv td-jdbc-0.2.10-jar-with-dependencies.jar /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib/
|The target directory is $SQUIRREL_SQL_INSTALL_PATH/lib/ on Windows and Linux.|
Step 3: Add Treasure Data JDBC Driver
Drivers at the left pane, and click + (the plus sign) to add a new driver.
Complete the information as shown in the following example.
- Name: Treasure Data
- Example URL:
- Java Class Path: td-jdbc-xxx.jar
- Class Name: com.treasuredata.jdbc.TreasureDataDriver
Step 4: Connect to Treasure Data
Aliases tab on the left pane and click + (the plus sign) to add the Alias.
- Name: Whatever you like
- Driver: Treasure Data
- URL: jdbc:td://api.treasuredata.com/< YOUR_DATABASE_NAME >;useSSL=true
- User Name: Your account email
- Password: Your account password
Test when the forms are filled. If the information is correct, you receive the message
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. Click
Ctrl + Enter when the query is ready. The query runs and then shows the results. You can check the progress of the query from Web console.