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.
Recommended Workflows
| Workflow | Use case | Main features |
|---|---|---|
| Explore Unknown Tables | Understand unfamiliar schemas | Explorer, table preview, AI Chat |
| Generate SQL with Ask AI | Turn business questions into SQL | Inline Ask AI, SQL Console Ask AI, schema context |
| Debug Slow Queries | Investigate expensive SQL | SQL Console, AI Chat, ClickHouse Monitoring |
| Build Charts from SQL | Shape query output for visualization | SQL Console, Charts & Results, AI |
| Save & Reuse Analysis | Preserve useful queries and team knowledge | Saved Queries, folders, descriptions |
Suggested Learning Path
- Explore schema with Explore Unknown Tables.
- Generate a first query with Generate SQL with Ask AI.
- Run and refine the query in SQL Console.
- Debug performance with Debug Slow Queries.
- Visualize stable output with Build Charts from SQL.
- Save reusable work with Save & Reuse Analysis.
How is this guide?