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.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| references/example-queries.md | 3.6 KB | text/markdown |
| references/permissions-setup.md | 10.8 KB | text/markdown |
| references/security.md | 6 KB | text/markdown |
| SKILL.md | 23 KB | text/markdown |
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
Content Strategy
anthropics
Turns PayPal, QuickBooks or Square sales data into a prioritized 30-day content brief for small businesses.
Cash Flow Snapshot
anthropics
Builds a 30/60/90-day cash flow forecast with confidence bands and named risk flags from ledger, payment or CSV data.
Pipeline Review
anthropics
Reviews CRM sales pipeline health by stage, flagging aging, stale and at-risk deals and checking coverage.
Metrics Review
anthropics
Reviews product metrics, analyzes trends against targets, and produces a scorecard with recommended actions.
Performance Report
anthropics
Builds marketing performance reports with key metrics, trend analysis, wins and misses, and prioritized optimization recommendations.
People Report
anthropics
Generates HR people-analytics reports on headcount, attrition, diversity, and org health from workforce data.