SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. You can use SQL Workbench/J as SQL authoring tool to interactively develop SQL queries with Treasure Data.
This article is created using a Mac OS. Your screens may differ on Windows and Linux.
Download the latest SQL Workbench/J installer from below, and install the application.
Follow the instructions at Installing and starting SQL Workbench/J.
SQL Workbench/J requires Java 7 or higher.
Download Treasure Data JDBC Driver
Download Treasure Data’s JDBC Driver from:
Add the Treasure Data JDBC Driver
File at the top menu, and click
Manage Drivers. Edit the forms:
Name: Treasure Data
Library: JDBC driver file path
Connect to Treasure Data
Click File at the top menu, and click Connect Window. Edit forms:
Name: Whatever you like
Driver: Treasure Data
Username: Your account email
Password: Your account password
Read only: True
Click OK to add the connection.
Issue the Query
You’ll see a list of tables and its columns by GUI.
Click the Statement tab, and edit the SQL query to be thrown.
Ctrl + Enter after the query is ready, then the query runs and shows the results.
You can check the progress of the query from TD Console.