AsterVale Living/Impact graph
Bundled AsterVale Living DataHub metadata RI
OBSERVED + DISCOVERED DEPENDENCIES

Dependency Intelligence

One view for DataHub lineage and the SQL consumers that catalog graphs cannot always observe.

stg_orders.customer_id
◇
DATAHUB LINEAGE4 observed assets

Column-level graph · maximum 3 hops

⌘
SQL SERVER MODULES4 hidden consumers

Static scan · one manual review

✓
EVIDENCE CONFIDENCEHIGH

Bounded to observed metadata

01

DataHub lineage

4 observed assets connected to the proposed field.

MCP EVIDENCE
SOURCEstg_orderscommerce-data@astervale.demo
H1
DATASETfct_order_salescommerce-analytics@astervale.demo
H2
CRITICALloyalty_customer_valueloyalty-platform@astervale.demo
H2
DATASETregional_returnsstore-operations@astervale.demo
H3
CRITICALexecutive_revenue_dashboardfinance-data@astervale.demo
✓ Fresh column lineage is available for the observed downstream assets.✓ Owners are known for the source and downstream assets.
02

Hidden SQL consumers

Read-only inspection of sys.sql_modules catches code-level dependencies beyond DataHub lineage.

Download discovery query
ObjectMatchRegionsConfidenceStatus
DBloyalty.usp_reconcile_loyalty_customerSQL_STORED_PROCEDURE CONVERT NORTHEAST, WEST HIGH FIX GENERATED
DBoperations.usp_match_regional_returnsSQL_STORED_PROCEDURE JOIN SOUTH, MIDWEST, WEST MEDIUM MANUAL REVIEW
DBfinance.vw_customer_revenue_bridgeVIEW CAST NORTHEAST, SOUTH, MIDWEST, WEST HIGH FIX GENERATED
DBexports.usp_export_customer_segmentsSQL_STORED_PROCEDURE DYNAMIC_SQL UNKNOWN LOW MANUAL REVIEW
03
PROPOSED SAFE ROLLOUT

Proposed safe rollout

Introduce a parallel typed field for `customer_id`, validate the safe cast from `varchar` to `bigint`, and migrate downstream consumers in stages.

parallel_typed_field
Next

See who must coordinate the change.

Regional metadata turns dependency findings into an owner-ready release map.

Open regional exposure →
TAKE IT WITH YOU

Download all results

Choose a ready-to-share text or PDF export for the full bundle or any individual result.

TXT bundle ↓PDF bundle ↓
Impact reportComplete evidence
TXTPDF
Discovery querySQL Server read-only scan
TXTPDF
Proposed fixesReviewable SQL drafts
TXTPDF
Validation queriesConversion and null checks
TXTPDF
Rollback runbookOwner-gated recovery steps
TXTPDF
SARIF resultsCI-compatible findings
TXTPDF