> For the complete documentation index, see [llms.txt](https://gyansetu-aws.gitbook.io/aws-cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gyansetu-aws.gitbook.io/aws-cloud/redshift.md).

# Redshift

*  Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud.
*  It provides a simple and cost-effective way to analyze all your data using existing Business Intelligence (BI) tool and SQL clients, regardless of the size of data.
*  It is designed to handle datasets from few hundred giga byte to a petabyte or more 
* Customers can start small for just $0.25 per hour with no commitments or upfront cost and scale to a petabyte or more for $1000 or more tera byte per year, less than a 10th of most other data base solution
*  Amazon Redshift handles all the data warehouse management activities for you, from provisioning the infrastructure to automating ongoing administrative tasks such as backup and patching. 
* Amazon Redshift is 10 times faster than traditional warehousing solution, because it stores the data in columnar form (columnar data storage). i.e. instead of storing data as a series of rows, amazon redshift organize data by column.
*  Data transferred in redshift is encrypted with SSL, data stored is encrypted by AES 256.

>  (note: we use BI or some web interface to use redshift)