Refresh "Amazon Redshift" dashboard using SYS views and add a query-level drill-down

**Is your feature request related to a problem? Please describe.**
The bundled dashboard `dashboards/redshift-monitoring.json` ("Amazon Redshift") is built on the legacy STL/STV system tables. This causes a few problems:

- It does not work on Redshift Serverless and Multi-AZ provisioned cluster, where STL/STV system tables are not queryable and the SYS monitoring views are the supported option.
- https://docs.aws.amazon.com/redshift/latest/dg/serverless_views-monitoring.html
- https://docs.aws.amazon.com/redshift/latest/dg/sys_view_migration.html
- https://docs.aws.amazon.com/redshift/latest/mgmt/monitoring-multi-az-query.html
- There is no bundled dashboard that lets an operator drill from a query list into a single query's execution detail (plan, per-phase timing, child queries, spill, etc.).

**Describe the solution you'd like**
Rebuild `dashboards/redshift-monitoring.json` on the unified `SYS_*` monitoring views while keeping the dashboard title "Amazon Redshift".

- Amazon Redshift dashboard (update): query activity, statement execution, transaction processing, auto table optimization, COPY/UNLOAD, data sharing, zero-ETL, schema insights, plus Serverless-only and Provisioned-only sections. The existing `STL_*`-based panels are kept under the Provisioned-only sections, so nothing is lost for provisioned users.
- Amazon Redshift Query Details dashboard (new): a per-`query_id` drill-down with query history, detail metrics, a flamegraph breakdown of query phases, full query text, query plan, child query text, external query detail, and COPY/UNLOAD detail.

**Describe alternatives you've considered**
Updating the existing "Amazon Redshift" dashboard (STL/STV) vs creating a new dashboard (SYS only). Decided to go with the first option since the existing "Amazon Redshift" dashboard since SYS views are the preferred option. Also, existing dashboard have multiple panels that are not working today and needs a fix anyway. We'll keep the current STL/STV based dashboard as-is with a mention of provisioned only.

**Additional context**
N/A

Open dashboards/redshift-monitoring.json and compare its STL/STV panels with the AWS SYS monitoring-view documentation linked in the issue. Map the requested query activity, monitoring, and Serverless/Provisioned sections, then plan the new query-details dashboard around query_id. Done means the existing dashboard is refreshed without losing provisioned coverage and the new dashboard provides the listed query-level details.

Written by the indexing model from the issue text.