Amazon Redshift
AWS's columnar data warehouse, PostgreSQL-flavoured SQL over provisioned clusters or serverless. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- Amazon Web Services
- Created by
- —
- First release
- 2012
- License
- Proprietary
- Open source
- No
- Pricing
- Paid
- Website
- https://aws.amazon.com/redshift
- Written in
- —
- Data model
- Relational
- Storage layout
- Column-oriented
- Workload
- Analytics (OLAP)
- Analytics architecture
- Data warehouse
- Query language
- SQL (PostgreSQL dialect)
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Managed cloud
- Scaling
- Natively distributed
- Create, read, update, delete
- Create: fast (COPY bulk loads from S3); Read: fast (Massively parallel columnar scans); Update: moderate (An update is a delete plus an insert); Delete: moderate (Rows marked deleted until VACUUM)