In the world of data analysis and manipulation, having the right tools at your disposal can make a significant difference in your productivity and efficiency. One such tool that deserves attention is the TD Query Tool (TDQT) extension for Visual Studio Code. This powerful extension empowers data professionals to perform complex queries and analyses within the familiar environment of VS Code.

• Treasure Data Query Tool

Setup

1. In the Extensions Marketplace, search for Treasure Data and find the Treasure Data Query Tool extension. Click on the "Install" button to install the extension.
2. After installation, go back to the Command Palette and search for TDQT Select API Host . Select this command and choose the desired endpoint from the available options.
3. Next, go to the Command Palette again and search for TDQT Add APIKEY . Select this command and enter your Treasure Data master API key when prompted.

Use

TDQT provides browsing and querying capabilities across your databases.

Browsing Databases, Tables and Saved Queries

1. After installing the extension, you will see the Treasure Data sidebar icon. Click on it to reveal the list of databases, tables, and saved queries.
2. Right-click on a database to access the following options:
   • Copy Database Name and Table Name - Copies the names of the selected database and table for later use.
   • Select Top 100 - Executes a query to select the top 100 rows from the table and displays the results.
   • Show Table Schema - Shows the schema of the selected table.
3. When expanding a database tree, the table schema will be displayed. Right-clicking on a column in the schema allows you to copy the column name for use in queries.
4. The Queries list displays saved queries that you can open in the editor.

Running Queries

1. To run a query, open a blank editor window or select a previously saved query.
2. Use the Command Palette (Ctrl+Shift+P or Cmd+Shift+P) and search for TDQT: Run Query . Select this command to start a new job on Treasure Data with the query from the current window.
3. An output window will show the progress of the job as it runs on the Treasure Data service.
4. Once the job is completed, another window will appear displaying the output of the query. You can inspect and analyze the results directly in the Visual Studio Code environment.

VS Code ecosystem

VS Code has a lot of great extensions that allow you to write SQL effectively. A combination of these extensions can help your day to day SQL life!

Here is some useful extensions I like!

• Prettier SQL VSCode : Formats SQL files using the sql-formatter library
• sqlfluff : A linter and auto-formatter for SQLFluff, a popular linting tool for SQL and dbt.

Appendix: Supported Commands