We performed a comparison between BigQuery and Microsoft Parallel Data Warehouse based on real PeerSpot user reviews.
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."The query tool is scalable and allows for petabytes of data."
"What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."
"The feature called calibrating the capacity is valuable."
"The most valuable features of BigQuery is that it supports standard SQL and provides good performance."
"The initial setup process is easy."
"As a cloud solution, it's easy to set up."
"The integrated data storage features are good."
"BigQuery can be used for any type of company. It has the capability of building applications and storing data. It can be used for OLTP or OLAP. It has many other products within the Google space."
"The data transmissions between the data models is the most valuable feature."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"Data collection and reporting are valuable features of the solution."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"Tools like the BI and SAS are excellent."
"One of the most important features is the ease of using MS SQL."
"The solution has been reliable."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"They could enhance the platform's user accessibility."
"With other columnar databases like Snowflake, you can actually increase your VM size or increase your machine size, and you can buy more memory and it will start working faster, but that's not available in BigQuery. You have to actually open a ticket and then follow it up with Google support."
"The processing capability can be an area of improvement."
"There are many tools that you have to use with BigQuery that are different services also provided for by Google. They need to all be integrated into BigQuery to make the solution easier to use."
"The initial setup could be improved making it easier to deploy."
"I rate BigQuery six out of 10 for affordability. It could be cheaper."
"We'd like to have more integrations with other technologies."
"There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans."
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."
"We find the cost of the solution to be a little high."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The product must provide more frequent updates."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"The product does not have all of the features that the native products have."
"The solution is expensive and has room for improvement."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews. BigQuery is rated 8.2, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and Apache Hadoop, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum. See our BigQuery vs. Microsoft Parallel Data Warehouse report.
See our list of best Cloud Data Warehouse vendors.
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.