SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database. You can use SQuirrelSQL as a SQL authoring tool to interactively develop SQL queries with Treasure Data.
Your screens might be different from these.
- Install SQuirrel
- Download Treasure Data JDBC Driver
- Add Treasure Data JDBC Driver
- Connect to Treasure Data
- Issue the Query
Download the latest SQuirreL SQL installer as a JAR file:
After you execute the JAR file, the installer starts.
Select Next to proceed through the installation.
Only the Standard pack is required for Treasure Data.
When the installation is complete, launch SQuirreL SQL.
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.
Select Drivers in the left pane, and select + (the plus sign) to add a new driver.
Complete the information as shown in the following example.
Name: Treasure Data
Example URL:
Hive: jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=hive
Presto: jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=presto
Java Class Path: td-jdbc-xxx.jar
Class Name: com.treasuredata.jdbc.TreasureDataDriver
Select the Aliases tab on the left pane and select + (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
Select Test when the forms are filled. If the information is correct, you receive the message
Connection is successful.
Select OK.
You’ll see a list of tables and their columns by GUI.
Move to the SQL pane, and edit the SQL query to be thrown. Select Ctrl + Enter when the query is ready. The query runs and then shows the results. You can check the progress of the query from the TD Console.
