# Redshift
#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.
- 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 $0.25 per hour with no upfront costs or commitments. Scale up to petabytes for $1000
