RedShift & Big Data
| Owner | |
|---|---|
| Verification | |
| Tags | |
| Last edited time |
RedShift
PostgreSQL OLAP data analytics and warehousing service for a peta byte scale
data is loaded from Kinesis, S3, DMS , can change node number for massive scale.
can set Multi AZ for failover , works within VPC, need to provision resources,
📢
good for sustained usage - use Athena for sporadic usage
Snapshots in S3 , can restore to a new cluster, can be copied to another region
Backup: auto - every 8h, or every 5gb or by time you set -can copy to another region for DR.
to export copy to another region :snapshot copy grant
for a master key in the destination region and enable cross-region snapshots in your Redshift cluster to copy snapshots of the cluster to another region.
RedShift Spectrum
Query data in S3 without loading - must have an existing cluster.
Concurrency Scaling
provides consistent performance (Concurrency scaling cluster)