Top Rated Amazon Redshift Alternatives
Video Reviews
399 Amazon Redshift Reviews
Overall Review Sentiment for Amazon Redshift
Log in to view review sentiment.
Quick to deploy, fast, and easy. Simplifies EDW deployments and allows you to align cost with consumption. Review collected by and hosted on G2.com.
On large datasets, it can take a while to scale up and down. Review collected by and hosted on G2.com.
User management and customizable functions. saves a lot of time to just write it once and have it reusable for all the analysts Review collected by and hosted on G2.com.
Occasional glitches and need to be rebooted to actually kill queries Review collected by and hosted on G2.com.
Redshift is faster than most traditional database. SQL knowledge is sufficient for using Redshift. No DBA required like tradtional DB Review collected by and hosted on G2.com.
Connection pool limit of 50 users. Queries perform slow when multiple sessions are running Review collected by and hosted on G2.com.
MPP architecture with jdbc & odbc connector with automated backup and neat integration with s3 direct loasding. Review collected by and hosted on G2.com.
unable to get scema level backup and also unable to set single sign on Review collected by and hosted on G2.com.
Ease of deployment and scability. The ability to ingest a diverse workloads and simultaneous conduct parrallel analytics Review collected by and hosted on G2.com.
Infestation of data has a single point of failure and bottleneck being addressed Review collected by and hosted on G2.com.
The flexibility and ease of use on the cloud and ability to manage all operations in one single place. Review collected by and hosted on G2.com.
Need to use it more to find out any disavantages Review collected by and hosted on G2.com.
The ability to store data in such a way for speedy data retrieval with reporting. Review collected by and hosted on G2.com.
There is a learning curve to how to query data that's in Redshift. Review collected by and hosted on G2.com.

Amazon Redshift is a robust software. Being a columnar data storage architecture makes it very efficient to query very large amount of data. We have several users who access and query Amazon Redshift but it does not affect the speed or efficency of the queries. It is compatible with several BI and visualization tools. We use Tableau in our organization to create reports and analytics. It is easier to setup and most of maintenance is managed by Amazon. This makes it less resource intensive and easier for your IT team. Review collected by and hosted on G2.com.
Not all features of Postgres SQL are supported by Amazon RedShift. There is no option to create variables which makes it difficult to write complex queries in certain scenarios. It also does not support stored procedures and triggers. Review collected by and hosted on G2.com.