Users report that Amazon Redshift excels in data integration with a score of 8.8, making it a preferred choice for enterprises looking to consolidate data from various sources. In contrast, Azure Cosmos DB, while versatile, received a lower score in this area, indicating potential challenges in seamless data integration.
Reviewers mention that Amazon Redshift's built-in data analytics feature scored 8.1, which some users find beneficial for quick insights. However, Azure Cosmos DB shines with its advanced data analytics capabilities, scoring 7.4, which may appeal to users needing more sophisticated analytical tools.
G2 users highlight that Amazon Redshift's ease of setup and administration both scored 8.6, suggesting a user-friendly experience for new users. Conversely, Azure Cosmos DB's ease of administration scored lower at 8.0, indicating that some users may face challenges in managing the database effectively.
Reviewers mention that Amazon Redshift's data compression feature scored 8.4, which helps in optimizing storage costs. In comparison, Azure Cosmos DB's data compression capabilities are not as robust, which could lead to higher storage expenses for users with large datasets.
Users on G2 report that Amazon Redshift's query optimization scored 6.7, which some users find lacking, especially for complex queries. Azure Cosmos DB, however, offers better query performance with a higher score, making it a more suitable option for users requiring efficient query execution.
Reviewers say that Azure Cosmos DB's security features, including role-based authorization and encryption, scored 8.7 and 8.6 respectively, providing a strong security framework. In contrast, Amazon Redshift's security features, while decent, did not match the level of confidence users have in Azure Cosmos DB's security measures.
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
Is Amazon redshift good for large datasets considering its cost.
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.