Redshift Guide
by aws0d6167ad2e6dNo license2.8K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated today
Amazon Redshift is NOT PostgreSQL — corrects PostgreSQL-derived LLM mistakes; covers Redshift-specific SQL, DDL, COPY/UNLOAD, system views, metadata discovery, and operational patterns. Applies ONLY when the task is about Redshift itself (cluster, Serverless workgroup, or Redshift SQL). Pushes back on: CREATE INDEX, string_agg, pg_catalog, text type, SERIAL, stl_query, LATERAL, RETURNING. Triggers on: Redshift SQL, Redshift CREATE TABLE, Redshift COPY/UNLOAD, slow Redshift query, Redshift permission denied, Redshift disk full, Redshift system views, QUALIFY, PIVOT, MERGE, Redshift Data API, Redshift WLM, concurrency scaling, Redshift resize, Redshift Spectrum external tables. Does NOT apply to (defer to that service's own skill): Amazon S3 storage/bucket policies, Athena or Glue queries/catalogs, data-lake or Iceberg work outside Redshift, Aurora, RDS, or DynamoDB — but S3/Glue ARE in scope for Redshift COPY, UNLOAD, or data-lake queries (external schemas/tables on S3).
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| references/redshift-sql-ddl-copy.md | 4.9 KB | text/markdown |
| references/redshift-sql-extensions-semantics.md | 4 KB | text/markdown |
| references/redshift-sql-functions-types.md | 4.2 KB | text/markdown |
| references/redshift-sql-materialized-views.md | 2.9 KB | text/markdown |
| references/redshift-sql-metadata.md | 9.2 KB | text/markdown |
| references/redshift-sql-recipes-load-api.md | 7.6 KB | text/markdown |
| references/redshift-sql-syntax.md | 4 KB | text/markdown |
| SKILL.md | 10 KB | text/markdown |
Source and attribution
Source:aws/agent-toolkit-for-awsinplugins/aws-data-analytics/skills/redshift-guideat commit0d6167a
License: No license
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from aws/agent-toolkit-for-aws
Signing In To Aws
aws
Guides developers through obtaining short-term AWS CLI/SDK credentials with the aws login command.
Aws Well Architected Review
aws
Reviews AWS workloads against the live Well-Architected Framework, evaluating every best practice and producing an evidence-backed report.
Aws Storage
aws
Advises on selecting, comparing, and operating AWS object, file, and block storage services.
Aws Serverless
aws
Routes AWS serverless requests to a compute form factor and the specialized skill that owns it.
Aws Security
aws
Reviews AWS security service configuration and summarizes findings across GuardDuty, Inspector, Security Hub, Macie, Detective and Security Lake.
Aws Sdk Swift Usage
aws
Reference patterns for writing Swift code with the AWS SDK for Swift package.
More in Data & Analytics
Spanner Basics
Guides Google Cloud Spanner administration, schema design, querying and performance diagnosis.
Gke Cost Analysis
Answers natural-language questions about GKE cluster and workload costs using BigQuery billing exports and live cluster metrics.
Datalineage Bigquery Asset Impact Analysis
Guides an agent through downstream impact (blast radius) analysis for a BigQuery table or view using Data Lineage.
Bigquery Troubleshooting
Diagnoses failing, slow, or unexpectedly expensive BigQuery jobs through structured root-cause workflows.
Bigquery Optimization
Guides BigQuery cost and performance optimization across capacity editions, storage layout, and SQL queries.
Bigquery Bigframes
Guides writing Python code with BigQuery DataFrames (BigFrames) for data processing, analysis, and machine learning.