QuestionQ71

VerifiedData Operations and Support

A data engineering team uses an Amazon Redshift data warehouse for operational reporting. The team wants to avoid performance issues that could result from long-running queries. A data engineer must select an Amazon Redshift system table to log anomalies when a query optimizer identifies conditions that could indicate performance issues.

Which table view should the data engineer use to satisfy this requirement?

Explanation

STL_ALERT_EVENT_LOG records alerts when the Amazon Redshift query optimizer detects conditions that might indicate performance problems, such as missing statistics, nested loops, selective filters, or inefficient data distribution. AWS documentation: STL_ALERT_EVENT_LOG

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!