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.
Add to a SourceWeft workspace
- Open the skill in your dashboard and add it to a workspace.
- Enable it for the chats that should use it.
This skill is instructions only: it ships no scripts to execute.
Add to SourceWeftYou will be asked to sign in first, then taken straight to this skill.
Ask your agent to install it
Paste this prompt into Claude Code, Codex, Cursor or another agent that can run commands — or into SourceWeft chat. The agent reads this skill's install guide, shows you its source, license and scripts, and installs it with the SourceWeft CLI once you agree.
Read https://sourceweft.com/skills/gh-aws-agent-toolkit-for-aws-querying-aws-redshift/install.md and install the skill it describes. Before installing, show me its source, license and whether it ships scripts, and wait for my OK. Ask me before changing anything else on my machine.Install it yourself from a terminal
For Claude Code, Codex, Cursor and other local agents. The SourceWeft CLI fetches the skill from its source repository at the commit scanned here, and verifies every file against the hashes recorded when the skill was scanned. If anything differs, nothing is written.
npx @sourceweft/cli skills install gh-aws-agent-toolkit-for-aws-querying-aws-redshiftAdd --agent claude-code, codex, cursor or universal to choose which agent gets it (Claude Code by default).
Upstream installer — not verified by SourceWeft
The open-source skills installer fetches the same pinned commit, but does not check the files against the hashes SourceWeft recorded.
npx skills add https://github.com/aws/agent-toolkit-for-aws/tree/188af2f810ce4df1b699cb55dd02f28bfa8eb2c8/skills/specialized-skills/system-table-skills/querying-aws-redshiftSource 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.