Monitoring Cloudera Data Warehouse with Cloudera Observability

Integrating Cloudera Data Warehouse on premises with Cloudera Observability allows you to collect query and job-level telemetry payloads. The dashboards help optimize Hive and Impala queries, ensure SLA compliance, and monitor performance.

Cloudera Data Warehouse integration with Cloudera Observability enables the collection and analysis of query and job-level metrics. This integration provides administrators and users with visibility into resource consumption, allowing them to monitor the health and performance of queries and jobs. By gathering these metrics, you can identify how resources are used and ensure that your critical workloads meet their Service Level Agreements (SLAs).

You can use the dashboards to optimize and troubleshoot Hive and Impala queries. These views help you set performance thresholds and understand individual query costs based on resource usage. This transparency helps you improve the efficiency of your overall workload footprint.

Feature highlights:

• Historical trends and baseline analysis: Establish performance benchmarks by analyzing long-term query patterns.
• Baseline scores for queries and anomaly detection: Identify performance deviations using baseline scores for queries.
• Query comparison: Compare query behavior and performance across different executions.
• Query health checks: Use health check features to monitor query status.
• Resource analysis widgets: Use dedicated widgets to perform query-level resource analysis.
• Cost tracking: Calculate the cost of queries based on actual resource consumption.

For information on integrating the Cloudera Data Warehouse cluster with Cloudera Observability, see Activating an environment in Cloudera Data Warehouse on premises.