Redshift Metric No Data Available.

Question

Hi all,

I'm currently working with Redshift.

Why  the metrics for Query duration, Query throughput, Query duration per WLM queue, Query throughput per WLM queue, Concurrency scaling usage, and Usage limit for concurrency scaling dashboard; are showing "No data available" ?

May i know why ? and how to solve this issue.

Thank you all.

Answer

Amazon Redshift maintain log files and corresponding log views only for 2 to 5 days of history. If your cluster has activity within the recent days then Query metrics should be displayed. Concurrency scaling, if enabled and used, then should be displayed.

Refer https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STL_tables.html

Redshift Metric No Data Available.

Conteúdo relevante