Querying Aws Redshift
by aws188af2f810ceNo license2.8K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated today
Enables Redshift system-table (SYS_*) log publishing to S3 Tables in Apache Iceberg format for both Provisioned clusters and Serverless namespaces, verifies publishing status, and queries the published logs via any Iceberg-compatible engine including Redshift and Athena. Covers system tables such as sys_query_history, sys_query_text, sys_connection_log, sys_query_detail, and sys_session_history. Applies when turning on S3 Tables log publishing for a cluster or namespace, confirming publishing status and locating the S3 Tables namespace, querying non-realtime data from Redshift system tables off-cluster at scale, or building dashboards for Redshift monitoring and auditing, especially for historical or high-volume system-table data beyond the in-cluster SYS_ view retention window. Trigger phrases: publish redshift system table log to s3 tables, enable-logging s3 tables, describe redshift logging status, query redshift system tables in athena or redshift, redshift log exports to iceberg.
- 188af2f810ceCurrentcommit 188af2fPublished Oct 8, 2026
Source and attribution
Source:aws/agent-toolkit-for-awsinskills/specialized-skills/system-table-skills/querying-aws-redshiftat commit188af2f
License: No license
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from aws/agent-toolkit-for-aws
Rds Oss
aws
Advises on Amazon RDS MySQL, MariaDB and PostgreSQL instance creation, upgrades, commitment pricing, RDS Proxy and Blue/Green deployments.
Exporting Rds To S3
aws
Guides exporting Amazon RDS or Aurora snapshots to Amazon S3 as Parquet, covering IAM, KMS, monitoring and verification.
Creating Amazon Aurora Db Cluster With Instances
aws
Guides creation of an Amazon Aurora cluster with instances, including Secrets Manager password handling.
Debugging Lambda Timeouts
aws
Diagnoses AWS Lambda timeout failures by analyzing configuration, CloudWatch logs and metrics, networking, cold starts, and dependencies.
Waf
aws
Routes AWS WAF configuration tasks to per-task reference procedures for filtering web traffic.
Creating Api Gateway Stage
aws
Creates and configures AWS API Gateway stages with logging, tracing, throttling, WAF and IAM roles.
More in Data & Analytics
Swap Curve Strategy
anthropics
Analyzes interest rate swap curves, swap spreads, real rates and curve trade ideas using MCP pricing tools.
Unit Economics
anthropics
Analyzes unit economics for private equity targets: ARR cohorts, LTV/CAC, net retention, payback and margin waterfall.
Option Vol Analysis
anthropics
Analyzes option volatility by combining vol surfaces, option pricing with Greeks, and historical prices to compare implied and realized vol.
Macro Rates Monitor
anthropics
Builds macro and rates dashboards from MCP data on GDP, inflation, yield curves, breakevens and swaps.
Clean Data Xls
anthropics
Cleans messy spreadsheet data: trims whitespace, fixes casing, converts text numbers, standardizes dates, and removes duplicates.
Fixed Income Portfolio
anthropics
Reviews fixed income portfolios by pricing bonds, aggregating risk metrics, projecting cashflows and running rate scenarios.