Review Pipeline
review_pipelineAnalyze a Coalesce pipeline to detect issues like redundant nodes, missing joins, and layer violations, and receive actionable improvement suggestions sorted by severity.
Instructions
Analyze an existing pipeline in a Coalesce workspace and suggest improvements. Walks the node DAG, inspects column transforms, join conditions, node types, naming conventions, and layer architecture to identify issues and optimization opportunities.
Returns findings sorted by severity (critical → warning → suggestion) with actionable fix suggestions.
Checks for:
Redundant passthrough nodes (no transforms added)
Missing join conditions (multi-predecessor nodes without FROM/JOIN)
Layer violations (skipping staging/intermediate layers)
Node type mismatches (View used for joins, Dimension in staging layer)
Orphan nodes (disconnected from the pipeline)
Deep chains (8+ nodes deep)
High fan-out risk (10+ downstream dependents)
Naming inconsistencies
Unused columns (>50% not referenced downstream)
Use nodeIDs to scope the review to a specific pipeline section (e.g., from a subgraph).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| nodeIDs | No | Optional list of node IDs to scope the review. If omitted, reviews the entire workspace (up to 50 nodes in detail). | |
| workspaceID | Yes | The workspace ID to review |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scope | No | ||
| summary | No | ||
| findings | No | ||
| warnings | No | ||
| nodeCount | No | ||
| analyzedAt | No | ||
| graphStats | No | ||
| methodology | No | ||
| workspaceID | No |