![]() This allows Amazon Redshift users to be notified and take timely actions without the need to query the system view. In the following sections, we walk you through how to set up automatic notifications of QMR violations to a Slack channel through the use of Slack events and alarms. We recommend that administrative team members periodically examine violations listed in the STL_WLM_RULE_ACTION table and coach the involved end-users on how to avoid future rule violations.Īlternately, a centralized team, using a Slack channel for collaboration and monitoring, can configure Amazon Redshift events and alarms to be sent to their channel, so that they can take timely action. If the action is aborted for the queries that violate a QMR, end-users see an error that indicates query failure due to violation of QMRs. ![]() When a query violates a QMR, Amazon Redshift logs the violation into the STL_WLM_RULE_ACTION system view. It also makes Amazon Redshift Spectrum metrics available, such as the number of Redshift Spectrum rows and MBs scanned by a query. This convenient mechanism lets you view attributes like the following: The Amazon Redshift cluster automatically collects query monitoring rules metrics. ![]() You can also use these rules to log resource-intensive queries, which provides the opportunity to establish governance for ad hoc workloads. The reason to use QMRs is to protect against wasteful use of the cluster. Rules that are applied to a WLM queue allow queries to be logged, canceled, hopped (only available with manual WLM), or to change priority (only available with automatic WLM). ![]() Amazon Redshift query monitoring rules are a feature of workload management (WLM) that allow automatic handling of poorly written queries. One of the challenges is to protect the data warehouse workload from poorly written queries that can consume significant resources. With Amazon Redshift, you can analyze your data to derive holistic insights about your business and your customers. In this post, we walk you through how to set up automatic notifications of query monitoring rule (QMR) violations in Amazon Redshift to a Slack channel, so that Amazon Redshift users can take timely action.Īmazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |