What is Redshift?
Amazon Redshift is a data warehouse and a part of the popular Amazon Web Services. This data analysis tool is perfect for storing your data. The platform is an analytical, fully-managed data warehouse that is capable of handling petabyte-scale data and enables analysts to run queries from it within seconds. Redshift offers limitless scalability on Amazon’s architecture, with no up-front costs.
Redshift is a cost-effective tool for data warehousing, analyzing nearly any data type using standard SQL. The Amazon Web Services platform allows you to automate the majority of common administrative tasks to monitor, manage, and scale your data warehouse. Redshift continuously monitors the health of the cluster, and automatically re-replicates data from failed drives and replaces nodes when needed.
- Redshift keeps all of our data together for analytics
- Allows users to store our large datasets in easily accessible databases.
- Redshift clusters are quick and easy to deploy.
- Some of the data analytics are difficult based on the size and clarity of data.
- Optimizing databases can be difficult at times.
- Because it is its own database with it's own syntax you can't 100% use postgres syntax or plug-ins directly.
- Doesn't have many options for desktop clients
Pricing for Amazon Redshift starts from $0.25 per hour for one Redshift instance, up to $1,000 per terabyte per year for larger deployments.