Investigate and resolve a failed Databricks and Snowflake production ingestion pipeline caused by invalid transactional records violating enterprise validation rules.
Pipeline
daily_sales_ingestion
Severity
HIGH
Executive dashboards are blocked after Snowflake rejected invalid records during the production ingestion workflow.
🚨 Incident Alert Received
PagerDuty triggered a HIGH severity production incident after Snowflake rejected invalid sales records violating enterprise validation rules.
Pipeline: daily_sales_ingestion
Environment: PROD
Severity: HIGH
Business Impact: Executive dashboards blocked
SLA Remaining: 42 minutes
Failed Records
Record ID: 91002
Negative Amount
REJECTED
Record ID: 91003
Null Amount
REJECTED
Record ID: 91005
Negative Amount
REJECTED
Spark Runtime Metrics
Records Processed
14.2M
Rejected Records
3
Executor Utilization
91%
Failed Stage
Validation
Production Engineering Workspace
Production Engineering Workspace
Incident Decision Engine
Choose the best production action to stabilize the pipeline while protecting SLA commitments.