Visit our new documentation site! This documentation page is no longer updated.

RazorSQL with Treasure Data

RazorSQL is a free, DBMS-independent, cross-platform SQL query tool. You can use RazorSQL as SQL authoring tool to interactively develop SQL queries with Treasure Data.

Table of Contents

Step 1: Install

Please download the latest SQL RazorSQL installer from below, and install the application.

Step 2: Download Treasure Data JDBC Driver

Please download Treasure Data’s JDBC Driver from below.

Step 3: Add Treasure Data Connection

Select Connections at the top menu, and click Connect. Then, please select OTHER as a connection type.

Then, please fill in Treasure Data JDBC driver information.

  • Profile Name: Treasure Data
  • Driver Location: JDBC driver file path
  • Driver Class: com.treasuredata.jdbc.TreasureDataDriver
  • Login: your email address
  • Password: your password
    • Hive: jdbc:td://< database >;useSSL=true;type=hive
    • Presto: jdbc:td://< database >;useSSL=true;type=presto
  • Auto Commit: off
  • SQL Restrictions: Read Only

Step 4: Issue the Query

You’ll see a list of tables and its columns by GUI.

Last modified: Aug 21 2015 23:48:03 UTC

If this article is incorrect or outdated, or omits critical information, let us know. For all other issues, access our support channels.