Workflows

Overview

Workflows document the most common analysis tasks in Dory. Each guide connects Connections, Explorer, SQL Console, AI Chat, Charts & Results, and Saved Queries into a repeatable process.

WorkflowUse caseMain features
Explore Unknown TablesUnderstand unfamiliar schemasExplorer, table preview, AI Chat
Generate SQL with Ask AITurn business questions into SQLInline Ask AI, SQL Console Ask AI, schema context
Debug Slow QueriesInvestigate expensive SQLSQL Console, AI Chat, ClickHouse Monitoring
Build Charts from SQLShape query output for visualizationSQL Console, Charts & Results, AI
Save & Reuse AnalysisPreserve useful queries and team knowledgeSaved Queries, folders, descriptions

Suggested Learning Path

  1. Explore schema with Explore Unknown Tables.
  2. Generate a first query with Generate SQL with Ask AI.
  3. Run and refine the query in SQL Console.
  4. Debug performance with Debug Slow Queries.
  5. Visualize stable output with Build Charts from SQL.
  6. Save reusable work with Save & Reuse Analysis.

How is this guide?

Privileges

Understand Dory privilege workflows for users, roles, permissions, and cluster operations.

Explore Unknown Tables with Dory

Use Dory Explorer, table preview, SQL Console, and AI Chat to understand unfamiliar database schemas quickly.

On this page

OverviewRecommended WorkflowsSuggested Learning Path