Treasure Data

Treasure Data Jobs API

Submit and manage query jobs

GitHub OpenAPI

Operations 12

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

POST /job/issue/presto/{database_name} Run a Presto SQL query on a database · Issue a Presto query job #
Ask an LLM
“How do I run a Presto SQL query against a Treasure Data database?”
“Can I set a priority when submitting a Presto query?”
Tell an agent
Run Presto query {query} on database {database_name}.
Submit Presto SQL {query} to {database_name} with priority {priority}.
POST /job/issue/hive/{database_name} Run a Hive query on a database · Issue a Hive query job #
Ask an LLM
“How can I submit a Hive query instead of Presto?”
“Can a Hive query job write its output to a result destination?”
Tell an agent
Run Hive query {query} on database {database_name}.
Submit Hive query {query} to {database_name} and send output to {result}.
GET /job/result/{job_id} Download the results of a finished query job · Get job results #
Ask an LLM
“How do I get the output rows of a query job once it's done?”
“What formats can I download job results in?”
Tell an agent
Get the results of job {job_id}.
Download results of job {job_id} as {format}.
GET /job/list List query jobs in the account · Get jobs #
Ask an LLM
“What jobs have been run in my account recently?”
“Where can I see a list of all my query jobs?”
Tell an agent
List my jobs.
Show every query job in the account.
GET /job/show/{job_id} Get details of a job · Get job #
Ask an LLM
“How do I see the full details of a specific job, like its query and database?”
“Can I look up a job by its ID to see what it ran?”
Tell an agent
Show job {job_id}.
Get the query and database used by job {job_id}.
GET /job/status/{job_id} Check a job's status by ID · Get job status by id #
Ask an LLM
“Is my query job still running or has it finished?”
“What was the status of a job's last execution?”
Tell an agent
Check the status of job {job_id}.
Tell me whether job {job_id} is still running.
GET /job/status_by_domain_key/{domain_key} Check a job's status by domain key · Get job status by domain_key #
Ask an LLM
“Can I find a job's status using the domain key I assigned instead of its job ID?”
“What's the status of the job I submitted with a particular domain key?”
Tell an agent
Check job status for domain key {domain_key}.
Find out if the job with domain key {domain_key} has finished.
GET /job/statistics/{job_id} Get a job's statistics · Get job statistics by id #
Ask an LLM
“How many records did a job insert?”
“Where can I see execution statistics for a finished job?”
Tell an agent
Show statistics for job {job_id}.
Tell me how many records job {job_id} inserted.
POST /job/issue/{job_type}/{database_name} Issue a job of any type on a database · Create job #
Ask an LLM
“Can I issue a job where I choose the job type in the path?”
“Is there a way to set a retry limit and resource pool on a new job?”
Tell an agent
Create a {job_type} job on database {database_name} running {query}.
Issue a {job_type} job on {database_name} in pool {pool_name} with retry limit {retry_limit}.
POST /job/kill/{job_id} Kill a running job · kill job by id #
Ask an LLM
“How do I stop a query that's taking too long?”
“Can I cancel a job that's already running?”
Tell an agent destructive · confirm first
Kill job {job_id}.
Stop running job {job_id} immediately.
POST /job/result_export/{job_id} Export a finished job's results to a destination · Set result export #
Ask an LLM
“How do I send the results of a job I already ran to a connection or table?”
“Can I export an existing job's output into another database table?”
Tell an agent
Export results of job {job_id} using connection {result_connection_id}.
Write results of job {job_id} into table {table} of database {database}.
POST /export/run/{database_name}/{table_name} Export a table to cloud storage · Create export job #
Ask an LLM
“How do I dump a whole table out to an S3 bucket?”
“Can a table export be limited to a time range and file format?”
Tell an agent
Export table {table_name} in {database_name} to bucket {bucket}.
Export {database_name}.{table_name} as {file_format} from {from} to {to}.

Documentation

📖
Documentation
https://docs.treasure.ai/apis/td-api

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/treasure-data/refs/heads/main/openapi/treasure-data-jobs-api-openapi.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/treasure-data:treasure-data-jobs-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

treasure-data-jobs-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Treasure Data Jobs API
  version: '1.0'
  description: 'Operations tagged Jobs across 2 of this provider''s published API definitions: treasure-data-td-api-openapi.yml, treasure-data-td-api-v3-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://api.treasuredata.com/v3
  description: Treasure Data API v3
- url: https://api.treasuredata.co.jp/v3
- url: https://api.ap02.treasuredata.com/v3
- url: https://api.eu01.treasuredata.com/v3
tags:


# --- truncated at 32 KB (32 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/treasure-data/refs/heads/main/openapi/treasure-data-jobs-api-openapi.yml