We performed a comparison between BigQuery and Microsoft Azure Synapse Analytics 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."
"It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."
"The product’s most valuable feature is its ability to manage the database on the cloud."
"BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights."
"It has a well-structured suite of complimentary tools for data integration and so forth."
"BigQuery excels at structuring data, performing predictions, and conducting insightful analyses and it leverages machine learning and artificial intelligence capabilities, powered by Google's Duarte AI."
"The integrated data storage features are good."
"Even non-coders can review the data in BigQuery."
"The whole solution is interesting for us."
"The setup is pretty simple."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"It is a highly stable solution and it's easy to use."
"The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"It's user-friendly and has a good dashboard."
"The process of migrating from Datastore to BigQuery should be improved."
"The main challenges are in the areas of performance and cost optimizations."
"It would be beneficial to integrate additional tools, particularly from a business intelligence perspective."
"It would be helpful if they could provide some dashboards where you can easily view charts and information."
"There are some limitations in the query latency compared to what it was three years ago."
"The processing capability can be an area of improvement."
"An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high."
"The price could be better. Compared to competing solutions, BigQuery is expensive. It's only suitable for enterprise customers, not small and medium-sized businesses, as they cannot afford this kind of solution. In the next release, it would be better if they improved their AI bot. Although machine learning and artificial intelligence are doing wonders, there is still a lot of room to enhance them."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"It could be more stable."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"The performance and data consistency need to be improved."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"I would like to see them provide the ingestion of images."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews. BigQuery is rated 8.2, while Microsoft Azure Synapse Analytics is rated 7.8. 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 Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and VMware Tanzu Data Services, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata. See our BigQuery vs. Microsoft Azure Synapse Analytics 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.