10. RedShift

CloudEng Course1 Lesson3 Redshift V1

Redshift

Redshift is a cloud data warehousing service to help companies manage big data. Redshift allows you to run fast queries against your data using SQL, ETL, and BI tools. Redshift stores data in a column format to aid in fast querying.

Tips

  • Redshift can be found under the Database section on the AWS Management Console.
  • Redshift delivers great performance by using machine learning.
  • Redshift Spectrum is a feature that enables you to run queries against data in Amazon S3.
  • Redshift encrypts and keeps your data secure in transit and at rest.
  • Redshift clusters can be isolated using Amazon Virtual Private Cloud (VPC).

What should a data warehouse, like Redshift, NOT be used for?

SOLUTION: processing day-to-day transactions