How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
We use Amazon S3 along with RedShift for storing our data. The data comes from various sources, including our client and third-parties. We get the data as an S3 file and then load it into RedShift using the ETL tools. RedShift will then act as the data source for Tableau, which is used for forecasting and other marketing activities.
My primary use for Amazon Redshift is for analytical purposes.
I'm the head of Data Warehouse and Business Intelligence, and our company is an Amazon customer. Most of the company's data sources were on Amazon at the time the product was deployed so it was logical to use this database. The data warehouse is quite small, compressed it's maybe 160 GB. It's not like an autonomous data warehouse or Exadata, which was almost 40 terabytes. It's a simple method of achieving extraction and loading. There is no real incremental load on this. Of course in the future, with the company growing, this should be changed and we'll probably need some kind of incremental system instead of this approach.
The primary use case for this solution is related to statistical data.
We primarily use the solution for analytics.
We are using the private cloud model of this solution. Our primary use case is for a data warehouse for BI.
We use it to build a data warehouse and a centralized location for all of our data sources, allowing for in-depth analysis by using SQL queries.