Exploring AWS !!
Day 77
Amazon Redshift
Fully managed data warehouse service in cloud. The data can be scaled up to petabytes and more.
Set of nodes called cluster, needs to be launched in order to create a database.
An Amazon Redshift data warehouse is a collection of computing resources called nodes, which are organized into a group called a cluster. Each cluster runs an Amazon Redshift engine and contains one or more databases.
Advantages:
Faster Performance:
Redshift delivers fast query performance even on large datasets. Uses ML to predict query runtime and assigns optimal queue for fast processing. Provides performance boost when executing repeated queries.
Easy to setup and deploy:
Provisions infrastructure of data warehouse automatically, making it easy to create new data warehouse. Also backs up data in S3
Cost-Effective:
Most cost effective data warehouse, where users pay only for what they use. The only database, offering on-demand pricing with no upfront costs.
Secure:
End to end encryption is provided. It takes care of key management. Enables users to configure firewall rules, providing full control over network access of data warehouse cluster.