aws cloud storage data-warehouse
It is a fully managed Petabase-sized Data Warehouse solution for by AWS. Redshift is singe AZ. Snapshots can be restored at a different AZ. usually data from various databases (RDS, DynamoDB, etc) will be loaded into redshift to perform OLAP queries.
Redshift Data Sourcees
We can fetch data from many places, like:
Use cases
- To perform complex queries on big data (structured and semi-structured data) with fast performance
- For Frequently accessed data with consistent structured format. See Redshift vs S3+Parquet Data Lake for trade-offs.
- S3 objects can be accessed wit Spectrum
- Managed data warehouse solution with: • Automated provisioning, configuration and patching • Data durability with continuous backup to S3 • Scales with simple API calls • Exabyte scale query capability
Pricing starts at 1000
