Query AWS Redshift System Tables Overview Works best with the AWS MCP server for sandboxed execution and audit logging. All commands below use the AWS CLI and work in any environment with configured AWS credentials. Use IAM roles or temporary credentials; avoid long-lived access keys. Redshift can publish system tables — the monitoring data such as , , and — to S3 Tables as continuously-updated Apache Iceberg tables. Terminology used throughout: system table refers to a dataset generally, and each one maps 1:1 to a published Iceberg table. Where this skill says view , it means specifically th…