About Amazon Redshift
Amazon Redshift is a cloud data warehouse from AWS. It is built to run SQL analytics on large amounts of data and to query data in open table formats.
What it does
Redshift can run queries across warehouse data and data lakes stored in Amazon S3. Serverless mode lets teams get results without managing infrastructure. It also powers SQL analytics in Amazon SageMaker, where data from the warehouse and the lake can be queried together.
Key features
- Serverless option with no infrastructure to manage
- Queries on open table formats such as Apache Iceberg
- Queries across warehouses and data lakes
- Access to third-party and federated data sources
- Instance types powered by AWS Graviton
Who it's for
Analytics engineers, data engineers and business intelligence teams that work on AWS. Teams that already use SageMaker may find the shared lakehouse useful.
Pricing and good to know
Redshift is priced on AWS terms, with serverless and provisioned options. Costs depend on the compute used and the data stored, so check the AWS pricing page for current rates. It is aimed at analytics workloads, so smaller datasets may be better served by a simpler database.
Highlights
- Serverless option with no infrastructure to manage
- Queries on Apache Iceberg tables
- Queries across warehouses and data lakes
- Access to third-party data sources
- Graviton-based instance types
