trino-cli

What problem does it solve?

This Skill provides expert assistance for using the Trino CLI to query Treasure Data interactively from the command line, enabling quick ad-hoc data analysis, exploration, and scripting without a web console. It streamlines terminal-based data workflows, saving time for data professionals.

Core Features & Use Cases

• Interactive Querying: Guides on connecting to TD, exploring databases/tables, and executing SQL queries directly from the terminal with immediate feedback.
• Batch Execution: Explains how to run queries from files or stdin, ideal for automation, scheduled reports, and integrating TD queries into shell scripts.
• Output Formatting: Demonstrates various output formats (CSV, JSON, Markdown) for integrating results with other tools or documentation, enhancing flexibility.
• Use Case: A data engineer needs to quickly check the schema of a new table, run a few ad-hoc queries to understand data distribution, and then export a small dataset to a CSV file for a colleague. This skill helps them use the Trino CLI for all these tasks efficiently from their terminal.

Quick Start

Install Trino CLI (if not already)

curl -o trino https://repo1.maven.org/maven2/io/trino/trino-cli/477/trino-cli-477-executable.jar chmod +x trino sudo mv trino /usr/local/bin/

Connect and query

export TD_API_KEY="your_api_key_here" trino
--server https://api-presto.treasuredata.com
--catalog td
--user $TD_API_KEY
--schema sample_datasets
--execute "SELECT COUNT(*) FROM nasdaq"