How To Install Squirrel Sql

SQuirreL SQL is an open up-source Coffee SQL Client plan for whatever JDBC compliant database. You can use SQuirrelSQL as a SQL authoring tool to interactively develop SQL queries with Treasure Data.

Your screens might be dissimilar from these.

Install SQuirrel

Download the latest SQuirreL SQL installer equally a JAR file:

SQuirrel SQL: Download and Installation

After you lot execute the JAR file, the installer starts.

Select Adjacent to continue through the installation.

Only the 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 Commuter:

JDBC Commuter Download

Then, put the driver into the SQuirreL SQL'southward commuter 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.

Add together Treasure Information JDBC Commuter

Select Drivers in the left pane, and select + (the plus sign) to add together a new commuter.

Complete the information as shown in the following example.

Name: Treasure Information
Example URL:
- Hive: jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=hive
- Presto: jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=presto
Coffee Class Path: td-jdbc-thirty.jar
Grade Name: com.treasuredata.jdbc.TreasureDataDriver

Connect to Treasure Data

Select the Aliases tab on the left pane and select + (the plus sign) to add the Alias.

Name: Whatever you similar
Driver: Treasure Data
URL: jdbc:td://api.treasuredata.com/< YOUR_DATABASE_NAME >;useSSL=true
User Name: Your account email
Password: Your account password

Select Examination when the forms are filled. If the information is correct, you receive the message
Connection is successful.

Select OK.

Issue the Query

You'll see a listing of tables and their columns by GUI.

Move to the SQL pane, and edit the SQL query to exist thrown. Select Ctrl + Enter when the query is gear up. The query runs and so shows the results. You tin check the progress of the query from the TD Console.