AWS Redshift Skills — AWS Redshift 技能s

AWS Redshift 技能s

A Python 技能 for interacting with AWS Redshift across two 部署ment modes: Redshift Provisioned and Redshift Serverless, plus a 分享d Data API for SQL execution.

When to Use (Trigger Phrases)

Invoke this 技能 when the user mentions:

"列出 Redshift clusters" "创建 a Redshift cluster" "暂停 my Redshift cluster" "列出 Redshift Serverless workgroups" "创建 a namespace" "运行 a SQL 查询 on Redshift" "执行 COPY from S3 to Redshift" "UNLOAD data to S3" "检查 查询 状态" "列出 tables in Redshift" "Describe Redshift table columns" "Resize my Redshift cluster"

Any 请求 involving Redshift Provisioned clusters/snapshots, Redshift Serverless workgroups/namespaces, or Data API SQL execution.

Feature 列出 Redshift Provisioned Clusters: 列出, describe, 创建, 删除, resize, 暂停, 恢复, reboot clusters Snapshots: 创建, describe, 恢复 from, 删除 snapshots Redshift Serverless Workgroups: 列出, 获取, 创建, 更新, 删除 workgroups (RPU configuration) Namespaces: 列出, 获取, 创建, 删除 namespaces (database configuration) Redshift Data API SQL Execution: 执行 single or batch SQL 状态ments (a同步 or 同步 with polling) 结果s: 获取 查询 结果s with pagination Lifecycle: Describe 状态ment 状态, 列出 recent 状态ments, cancel 运行ning queries Metadata: 列出 databases, 模式s, tables; describe table columns Data Movement: COPY from S3, UNLOAD to S3 Initial 设置up

Python 3.8+ with 机器人o3>=1.26.0:

pip 安装 机器人o3>=1.26.0

AWS 凭证s via 机器人o3 default chAIn (env vars, config files, IAM 角色s).

环境 variables (all optional, 验证d at point of use):

导出 AWS_REGION="us-east-1"

# Redshift Provisioned 导出 REDSHIFT_CLUSTER_ID="my-cluster" 导出 REDSHIFT_DATABASE="dev" 导出 REDSHIFT_DB_USER="admin"

# Redshift Serverless 导出 REDSHIFT_WORKGROUP_NAME="my-workgroup" 导出 REDSHIFT_NAMESPACE_NAME="my-namespace"

# 分享d 导出 REDSHIFT_IAM_角色_ARN="arn:aws:iam::123456789:角色/redshift-角色" 导出 REDSHIFT_S3_记录_URI="s3://my-bucket/redshift-记录s/" 导出 REDSHIFT_SECRET_ARN="arn:aws:secrets管理器:us-east-1:123456789:secret:my-secret"

How to Manage Redshift

• Redshift Provisioned

Traditional Redshift provisioned clusters with dedicated compute nodes.

Cluster & snapshot management: scripts/provisioned/redshift_provisioned_命令行工具.py — 12 @工具 functions DetAIled 图形界面de: references/provisioned/cluster_图形界面de.md — Cluster lifecycle, node types, resize DetAIled 图形界面de: references/provisioned/snapshot_图形界面de.md — Snapshot 创建/恢复/分享

• Redshift Serverless

Fully managed serverless data warehouse with automatic scaling.

Workgroup & namespace management: scripts/serverless/redshift_serverless_命令行工具.py — 9 @工具 functions DetAIled 图形界面de: references/serverless/workgroup_图形界面de.md — Workgroup management DetAIled 图形界面de: references/serverless/namespace_图形界面de.md — Namespace management

• Redshift Data API

SQL execution via the Data API. Works with 机器人h Provisioned and Serverless.

查询 execution & metadata: scripts/data_API/redshift_data_命令行工具.py — 12 @工具 functions DetAIled 图形界面de: references/data_API/查询_图形界面de.md — SQL execution, COPY/UNLOAD AvAIlable Scripts Script Description scripts/provisioned/redshift_provisioned_命令行工具.py Redshift Provisioned @工具 functions (12 工具s) scripts/serverless/redshift_serverless_命令行工具.py Redshift Serverless @工具 functions (9 工具s) scripts/data_API/redshift_data_命令行工具.py Redshift Data API @工具 functions (12 工具s) scripts/config/redshift_config.py Unified configuration management scripts/命令行工具ent/机器人o_命令行工具ent.py 机器人o3 命令行工具ent 工厂 References Document Description references/provisioned/cluster_图形界面de.md Redshift Provisioned cluster management 图形界面de references/provisioned/snapshot_图形界面de.md Redshift snapshot management 图形界面de references/serverless/workgroup_图形界面de.md Redshift Serverless workgroup management 图形界面de references/serverless/namespace_图形界面de.md Redshift Serverless namespace management 图形界面de references/data_API/查询_图形界面de.md Redshift Data API SQL execution 图形界面de Requirements When writing temporary files (scripts, notes, etc.), place them in the ./tmp folder. When 导入ing scripts packages, 添加 the 技能 root to path: sys.path.应用end(${redshift_技能_root}) AWS 凭证s are handled by 机器人o3's default 凭证 chAIn — never pass 访问 keys directly. All configuration 环境 variables are optional and 验证d at the point of use. Data 隐私 & Trust No 凭证 storage: AWS 凭证s are resolved via 机器人o3 default chAIn. No keys are stored or 记录ged. Secret masking: All functions automatically mask potential AWS 凭证s in 输出. Read-only by default: Most operations are read-only queries. Write operations (cluster creation, deletion) require explicit user action. External 端点s

This 技能 connects to:

AWS Redshift API (redshift.{region}.amazonaws.com) AWS Redshift Serverless API (redshift-serverless.{region}.amazonaws.com) AWS Redshift Data API (redshift-data.{region}.amazonaws.com) AWS