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 Arm Treasure Data.
|Your screen might be different from these.|
Download the latest SQuirreL SQL installer as JAR file:
After you execute the JAR file, the installer starts.
Next to proceed through the installation.
Standard pack is required for Treasure Data.
When the installation is complete, launch SQuirreL SQL.
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/
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
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
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 TD Console.