How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
We are premium partners with Amazon.
Redshift is a managed service for data warehouses.
Our primary use case of this product is as a data warehouse. We are partners with Amazon.
We are a solution provider and Amazon Redshift is one of the products that we implement for our clients. We are working with a few customers that have it implemented right now.
We are a service provider and we currently have five clients with active IT implementations that use Amazon Redshift. We also use it ourselves. My clients primarily use this product for data analytics. They are mostly working with big data and using the machine learning functionality.
We are a digital transformation services company, and we are using Amazon Redshift for one of our clients. They are a logistics company that has transportation and other needs. Their first requirement is for financial reporting, where we pull financial data from their many ERP systems and can provide a corporate-level view. There is also an operations standpoint, where they are looking for operational insights. For this, we again pull different information from their ERPs, bring it into Redshift, and then model it in such a way that they will be able to see a consolidated view in terms of operational success across lines of business.
We stored all of the data in the S3 bucket and would like to have it stored in a data warehouse, which is why we chose this database. It would be very easy for us as an end-user, who would like to access the data, rather than draw it post-transformation and store it at a database level.
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.
Which is better and why?