Amazon Redshift is AWS's fully managed, petabyte-scale data warehouse built on PostgreSQL that uses massively parallel processing and columnar storage for high-performance analytics. The platform offers provisioned clusters with RA3 nodes that decouple compute from storage, and Redshift Serverless for automatic scaling without
Table of contents
Amazon Redshift Overview (and comparison to Snowflake)Architecture OverviewMPP and columnar storageNode types and managed storageServerless workgroupsDeployment and SetupTwo options: Creating a cluster or a workgroupNetwork and security configurationConnecting to RedshiftRedshift UIData IngestionCOPY commandZero‑ETL and streaming integrationsRedshift Spectrum and Federated QuerySchema Design and Performance TuningDistribution stylesDISTKEY Selection guidelinesSort keys and compressionSORTKEY Selection GuidelinesWorkload Management (WLM) and concurrency scalingMaintenance OperationsVacuumingANALYZE commandMonitoring and alertsCommon Errors and TroubleshootingBest PracticesSummaryWhen to Use Snowflake vs RedshiftWhat’s Next?Sort: