What's special about Amazon Redshift is that it constantly offers new features to meet the demands of increasingly large data stores. It is undoubtedly the best solution for data storage and processing in the cloud. If you are not yet a user, I highly recommend it.

It takes time to get up to speed with all the features of Amazon Redshift.

Redshift has given us a viable OLAP data warehouse which speeds up all of our analytical workloads. The main benefits we got are speed, ease of use, and reliability, which in turn gave us more time to work on other projects and also much better visibility of our products and business.

Redshift is a reliable cloud data warehouse that's easy to set up especially if your tech infra already runs on AWS.

Scaling out/up/down is quite limited with Redshift. The elastic resize is supposed to help on this but it's still limited to just halving/doubling your current cluster. It's not as flexible as Snowflake or BigQuery. Also, the max concurrency of 50 is quite low compared to other cloud data warehouses.

In my Opinion AWS redshift is an average product, the syntax and methods you have to use if you are used to using SQL server you will find to be more long winded or searching for alternatives ways. Basic items like parameters in stored procedures after a lot more complex than required.

It is a good tool for combining multiple data sources into one place. It is not really useful to load data in a delta approach but to fully reload the data source.

Its ETL process always wants you to create objects as S3 objects which most of the time is fine but you then end up storing the data twice, once in the 3s and then again in Redshift unless you code to delete the S3 files after loading.

Redshift is the bedrock upon which our entire product lives. It stores the underlying data for our reporting, dashboards, etc.

Redshift is a great starting point for storing data if you're planning to build out a stack using other AWS products (EMR clusters, S3 for browsing, etc.). Redshift is reliable/dependable, we haven't faced uptime issues or anything like that. Easy to query against which is essential for us when pulling reports or performing QA. In previous work I've also been able to hook Redshift up directly to Tableau which has been huge in building ad-hoc reporting directly from our datastore.

Integrations aren't always as intuitive as with other tools, but this can be avoided with a solid internal knowledge base.

Amazon Redshift helped us creating standard reports for advertising activities and proved to be a valuable data source for our visual dahsboards

Amazon Redshift allowed us to organize efficiently all our data, both for reporting and visualization purposes. You can use SQL syntax to query the tables and to extract all the info you need. It supports multiple datatypes with many data compression solutions to save disk space and money. The Amazon Redshift console (on the AWS dashboard) allows you to keep track of your db performances, from query execution time to disk space used, and displays also wise recommendation on how to manage properly your tables.

There is nothing I can complain about Amazon Redshift.

Overall the Redshift experience is great and it can be used build your data warehouses.

The Redshift provided various data connector to get data from different sources . The data distribution can be defined while creating a table , which helps the SQL query to minimize the i/o operations , which intern increases the speed of the reports .

The redshift data distribution in disk is difficult at times to decide when you are build large data warehouses . The rival product like snowflake make it easy for the users as all of the data distributions are being taken care internally.

I was satisfied with Amazon Redshift. It works fairly well, but ultimately competitors had a better offer, regarding features, scailing and pricing flexibility, and that is why we moved away from it.

Redshift was surprisingly easy to deploy as a total begginer. Once it was up, it was always very stable and we didn't have any issues.

Redshift is very much behind its competitors in offering better features for administrators. Its permission structure is ancient (comparing to Snowflake roles) and you're completely on your own for taking care of safety. As expected, we don't have consumer support and no account manager has ever contacted me.

Easy to use, fast query speed, highly scalable, robust security and easy to upload data via AWS. Pricing is fair.

Table configuration process can be improved to make things easier.

Mostly positive once it is set up but the set up can be extremely challenging

I like that it was accessible across multiple devices and I like that it was possible to integrate with RStudio. That being said, sometimes my connections would just break if I didn't have the most up to date jar file and it was sometimes hard to figure out which jar file was the right one for the new version.

At times, my ODBC connections would just break or give weird errors and after hours of scrolling through the documentation, I am still confused

The speed, reliability, and ease of use are top of mind. The setup makes it easier for developers to specify priority and rules around processes and queries, also AI-powered capabilities in the background can be an enormous aid.

The complexity of documentation, which is huge, and it can be challenging to find a specific answer).

I like that Redshift is integrated with AWS and able to work with many AWS items, such as S3 buckets, and that it uses IAM for security. There's also a good range of AWS documentation, so in that regard, if you're an AWS environment it offers a lot of integration.

Redshift's UX leaves something to be desired. It has a query editor, and now a V2 query editor, but they're not awesome interfaces. Also some things you want to schedule you can only do if you create a Python-based AWS lambda rather than being able to do in Redshift itself - and even then you need to statically import a Python PostgreSQL library to connect to Redshift. It's all kind of disjointed.

El rendimiento sin ningun tipo de duda, es potentísimo.

que no tenga un cliente de administración a la altura

他のＡＷＳ製品だけでなく、ニッチな製品を含む多くのツールとデータのやり取りを行うことができる。

ＳＱＬ言語をベースとしたコードなので、複雑なＥＴＬが必要な場合、コードが不要に長くなってしまったり、分かりにくく書かなければならない時がある。２０２２年初めにＰＩＶＯＴ関数が導入されたりと柔軟性は高まってきているものの、ループ処理など含め、やはり他のＥＴＬツールと比べると開発しづらい面がある。

Redshift is a good data warehouse, if you have a good devops teams, it follows the rules of AWS so the setup good be ok.

Difficult to optmize, it could become quite expensive, and you need specialist if you want to use it well