Zum Inhalt springen
Kitbay
Einreichen

redshift-guide

Apache-2.0Aktualisiert am 11. Nov. 20263.464GitHub-Sterne

A skill from AWS's aws-data-analytics plugin that corrects common model mistakes about Amazon Redshift, starting from the point that it is not PostgreSQL, and pushes back on features Redshift lacks, such as CREATE INDEX or SERIAL.

Was der Skill vermittelt

A skill from AWS's aws-data-analytics plugin that corrects common model mistakes about Amazon Redshift, starting from the point that it is not PostgreSQL, and pushes back on features Redshift lacks, such as CREATE INDEX or SERIAL. It asks whether the cluster is provisioned or Serverless, then covers Redshift SQL, system views and metadata, connections and authentication, storage growth and VACUUM, slow queries and EXPLAIN plans, workload management and concurrency scaling, resizing, Spectrum, and using the Redshift Data API from Python. It includes safety guardrails and security notes.

Funktionen

  • Write Redshift-specific SQL
  • Diagnose slow Redshift queries
  • Manage Redshift storage, VACUUM and workload management
  • Use the Redshift Data API from Python