Discovery & Exploration

Impact Analysis

Understand the blast radius of proposed changes before making schema changes or deprecating old tables.

Prompt Template

Copy Template

Analyze [PIPELINE] to identify components that reference [TABLE/COLUMN]:- Show all downstream dependencies- Identify potential breaking changes- Suggest testing strategy

Retail

Industry Example

Copy Example

If I change ERC_SALES_TRANSACTIONS.payment_method from VARCHAR(50) to VARCHAR(20), what pipelines are affected?- Show all downstream dependencies in customer-analytics and store-performance folders- Identify potential breaking changes (some new payment methods like "CRYPTOCURRENCY_WALLET" may be truncated)- Suggest testing strategy for our 47 production pipelines

Prompt Details