Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
I would rate my experience with technical support around six on a scale of 1 to 10 because I have not had a particular experience with technical support.
The Snowflake Analytics documentation is excellent.
Recently we had a two-day session where the Snowflake Analytics team provided a demo on Cortex AI and its features.
The technical support for Snowflake Analytics is excellent based on what I have heard from others.
I give the scalability an eight out of ten, indicating it scales well for our needs.
As a consultant, we hire additional programmers when we need to scale up certain major projects.
Storage is unlimited because they use S3 if it is AWS, so storage has no limit.
It supports both horizontal and vertical scaling effectively.
Maintaining security and data governance becomes easier with an entire data lake in place, and the scalability improves performance.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
Snowflake Analytics has been stable and reliable in my experience.
Snowflake Analytics is stable, scoring around eight point five to nine out of ten.
The Power BI team raised tickets for both Power BI and Snowflake Analytics, and their responses were very good.
It would be better to release patches less frequently, maybe once a month or once every two months.
Addressing the cost would be the number one area for improvement.
When there are many users or many expensive queries, it can be very slow.
AIML-based SQL prompt and query generation could be an area for enhancement.
If it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better.
I would prefer Snowflake Analytics to improve their support response times, as sometimes the responses we receive are not very prompt and ticket assignments may not be timely.
Microsoft Parallel Data Warehouse is very expensive.
Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query.
Snowflake is better and cheaper than Redshift and other cloud warehousing systems.
Snowflake Analytics is quite economical.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
Microsoft Parallel Data Warehouse is used in the logistics area for optimizing SQL queries related to the loading and unloading of trucks.
There's a feature that allows users to set alerts on triggers within reports, enabling timely actions on pending applications and effectively reducing waiting time.
Running a considerable query on Microsoft SQL Server may take up to thirty minutes or an hour, while Snowflake executes the same query in less than three minutes.
Snowflake Analytics supports data security with a single sign-on feature and complies with framework regulations, which is highly beneficial.
It is a data offering where I can see data lineage, data governance, and data security.
Company Size | Count |
---|---|
Small Business | 16 |
Midsize Enterprise | 6 |
Large Enterprise | 21 |
Company Size | Count |
---|---|
Small Business | 10 |
Midsize Enterprise | 12 |
Large Enterprise | 21 |
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.
To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.
Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.