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.|
Step 1: Install SQuirrel
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
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/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 hit plus button to add a new driver.
Please fill the information like below.
- Name: Treasure Data
- Example URL:
- 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://api.treasuredata.com/< YOUR_DATABASE_NAME >;useSSL=true
- User Name: Your account email
- Password: Your account password
Test once the forms get filled. If the information is correct, it will say
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.