Creating a Directory of Saved Workflows and Queries

Copy

• Copy for LLM

  Copy page as Markdown for LLMs
• View as Markdown

  Open this page as Markdown
• Open in ChatGPT

  Get insights from ChatGPT
• Open in Claude

  Get insights from Claude
• Connect to Cursor

  Install MCP server on Cursor
• Connect to VS Code

  Install MCP server on VS Code

This example creates a workflow that runs a saved job on Treasure Data to import data, runs a query, and then exports query results to an external database or service.

• Create a Workflow Directory
• Add the Workflow Definition File

1. Set up TD Workflows.

2. Create a directory called wf_of_saved_queries.

$ mkdir wf_of_saved_queries

Add the Workflow Definition File

Add the workflow file itself. In this case, you need to replace the <replaced_with_saved_query_name> with your query's saved name in Treasure Data .

$ cat > saved_queries.dig <<EOF
_export:
  td:
    database: workflow_temp

+data_load_task:
  td_load>: <replace_with_saved_data_connector_job_name>

+query_task:
  td_run>: <replace_with_saved_query_name>
EOF

To find a saved data connector job, you can issue the following command using td-toolbelt via CLI:

$ td connector:list

From your TD Console, you can review the list of saved queries and their definitions.