DJames617 AWS Service
Amazon Redshift
Redshift is a managed data warehouse for analytics at scale.
What This Service Solves
Redshift is a managed data warehouse for analytics at scale.
- Use Redshift for structured analytical workloads, BI, complex joins, and high-performance warehouse queries.
When You Should Not Use It
- Avoid Redshift when occasional ad hoc S3 queries are enough. Athena may be simpler and cheaper.
What AWS Manages and What You Manage
AWS manages the service platform. You manage schema design, workload management, distribution/sort choices, security, and cost controls.
Security Implications
Use IAM, KMS, VPC, audit logging, column-level controls, and federation where appropriate.
Availability and Scaling
Redshift provides managed durability and recovery options, but architecture choices affect availability and maintenance.
Serverless, RA3, concurrency scaling, and materialized views help different patterns.
Cost Behavior
Node/serverless capacity, storage, concurrency scaling, snapshots, and data transfer drive cost.
Common Integrations
- S3
- Glue
- Athena federation
- QuickSight
- Lake Formation
How AWS Might Present It
Certification-Specific Depth
Data Engineer Associate
Know configuration choices, integrations, failure modes, security, operations, and cost tradeoffs.
Related Comparisons
Sources and Review Metadata
This independent training application is not affiliated with or endorsed by Amazon Web Services. AWS, Amazon Web Services, and AWS certification names are trademarks of Amazon.com, Inc. or its affiliates.