Treasure Data Query Tool 💎

Visual Studio Code extension that allows the user to run queries against their Presto or Hive databases

Configuration

Basic Setup

Set the API host via the command palette: TDQT: Select API Host Domain

Set the API Key via the command palette: TDQT: Add API Key. Add an API key with Read permissions on the account.

Creating Presets

If multiple accounts and domains are needed, presets are configurable for reuse.

Using the command palette, run the command TDQT: Add Preset and fill in the fields in order:

• Name for this preset, e.g. default
• Select the Treasure Data domain for the account; api.treasuredata.com or api.treasuredata.co.jp
• The API key with READ access to the account

Then you can select this preset at any time with the TDQT: Select Preset command.

Usage

This tool provides browsing and querying capabilities across the databases accessible via the API keys provided.

Databases, Tables and Saved Queries

Use the Treasure Data sidebar to reveal the list of databases, tables and saved queries.

Each database listed has a right-click context menu to Copy Database Name or Select Database - Database selection is important when querying.

Under each database is the listing of tables. The context menu allows to Copy Database and Table Name and to Show Table Schema. The Show table schema action opens a window with column name and type information.

When the database tree is expanded it will also show the table schema. The context menu allows to Copy the column name for use in Queries

The Queries list allows users to open saved queries in the editor. Use the right-click context menu to Open the query

Running Queries

From either a blank editor window or an previously saved query, run the command palette TDQT: Run Query to begin a new job on Treasure Data with the query in the window.

An output window will show progress of the job as it is run on the Treasure Data service. When completed, another window appears with the output of the query. Users can inspect and look through the results from the VS Code environment.

Support

This extension is provided as a free tool for users of Treasure Data. Please contact support if you have feedback or issues.