What users are saying about
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.4 out of 100
Based on 15 reviews and ratings
Top Rated
112 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.7 out of 100
Based on 112 reviews and ratings
Likelihood to Recommend
Azure Synapse Analytics (Azure SQL Data Warehouse)
It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards

Verified User
Contributor in Information Technology
Information Technology and Services Company, 10,001+ employeesGoogle BigQuery
BigQuery is unlike anything we've used as a big data tool. It is perfectly suited to query large data sets quickly and to store those large data sets for any time use. It's perfect for storing data and using it for reports. Logging data is the perfect application for BigQuery, but transactional data is possible as well
Vice President of Shared Services
CloudbakersComputer Software, 51-200 employees
Feature Rating Comparison
Database-as-a-Service
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
9.0
Automatic software patching
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
9.3
Database scalability
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
9.4
Automated backups
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
8.8
Database security provisions
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
8.8
Monitoring and metrics
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
8.8
Automatic host deployment
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Google BigQuery
9.0
Pros
Azure Synapse Analytics (Azure SQL Data Warehouse)
- It is very cost-effective
- Development time needed was much less in comparison to other systems
- Played very nicely with our ETL and OLAP reporting tools
SQL Development Team Lead
Allianz Asset ManagementInvestment Management, 1001-5000 employees
Google BigQuery
- How many pros can a person type? This storage program gives workers and students the reality of unlimited storage space. I have never came close to overfilling my google cloud storage because it's huge and the best. I can view anything I save on there from any of my internet devices which is very important.
- Depending on how you have the program set up - either online or through an application that lives on your desktop, dragging and dropping files to and from Cloud Storage couldn't be any more uncomplicated. Plus, new users who meet certain criteria - like updating personal security, or share the program receive additional free online storage.
- The array of tools is very impressive, intuitive to use, and well organized in the sense that you don't have to go looking for individual apps. They're all easily accessed via a single dropdown.
Head of Digital Marketing
YachtLifeInternet, 11-50 employees
Cons
Azure Synapse Analytics (Azure SQL Data Warehouse)
- Limited T-SQL query library
- It is not suitable for OLTP environment
- Doesn't support cross-database queries
Associate - Project
CognizantInformation Technology & Services, 10,001+ employees
Google BigQuery
- Though it is SQL some syntax are different but they are getting used to after you use for some time.
- The legacy SQL is in beta state but can be used and you can run the query with simple SQL.
- More documentation is needed for using User-defined functions in Big Query.

Verified User
Analyst in Information Technology
Internet Company, 11-50 employeesUsability
Azure Synapse Analytics (Azure SQL Data Warehouse)
Azure Synapse Analytics (Azure SQL Data Warehouse) 8.0
Based on 1 answer
It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.
Associate - Project
CognizantInformation Technology & Services, 10,001+ employees
Google BigQuery
Google BigQuery 9.0
Based on 1 answer
BigQuery is a little bit difficult to learn at first. The tools are all there but it takes a few hours of practice and trial and error to be comfortable processing a large dataset. It can handle quite a bit and the cloud storage makes those experimental practice hours much easier to do in your spare time. The software is capable of doing a lot, it's just a matter of being patient and learning the ways of BigQuery.

Verified User
Employee in Professional Services
Environmental Services Company, 1-10 employeesSupport Rating
Azure Synapse Analytics (Azure SQL Data Warehouse)
Azure Synapse Analytics (Azure SQL Data Warehouse) 8.1
Based on 3 answers
I like their Support team

Verified User
Consultant in Information Technology
Information Technology and Services Company, 10,001+ employeesGoogle BigQuery
Google BigQuery 8.4
Based on 16 answers
I rated the overall support for Google BigQuery as a mediocre five because it has limited support from Google. Instead, it is heavily dependent on an organization's IT resources such as SQL analysts and Data Architects to run big data reports or maintain data quality. Additionally, if errors occur during a run of complex SQL queries or when sending data to Google BigQuery from other sources, Google provides basic email support which needs to be complemented with internal data warehouse support to fix the root cause of the database errors. Finally, due to constraints on the amount of data an analyst can query or pay the additional cost when exceeding the limit, basic Google support is not sufficient to meet data needs without interruption.

Verified User
Analyst in Marketing
Food & Beverages Company, 10,001+ employeesAlternatives Considered
Azure Synapse Analytics (Azure SQL Data Warehouse)
SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data

Verified User
Contributor in Information Technology
Information Technology and Services Company, 10,001+ employeesGoogle BigQuery
Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
Software Engineer
SportsBoard Mobile Player Assessment SolutionsResearch, 1-10 employees
Return on Investment
Azure Synapse Analytics (Azure SQL Data Warehouse)
- We have had an improvement in our overall processing time
- Cost was much lower than most of its competitors
- Our reporting needs have grown and housing the data here has been great
SQL Development Team Lead
Allianz Asset ManagementInvestment Management, 1001-5000 employees
Google BigQuery
- Google BigQuery has had enormous impact in terms of ROI to our business, as it has allowed us to ease our dependence on our physical servers, which we pay for monthly from another hosting service. We have been able to run multiple enterprise scale data processing applications with almost no investment
- Since our business is highly client focused, Google Cloud Platform, and BigQuery specifically, has allowed us to get very granular in how our usage should be attributed to different projects, clients, and teams.
- Plain and simple, I believe the meager investments that we have made in Google BigQuery have paid themselves back hundreds of times over.
Solution Architect
Ovative/groupMarketing and Advertising, 51-200 employees
Pricing Details
Azure Synapse Analytics (Azure SQL Data Warehouse)
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Azure Synapse Analytics (Azure SQL Data Warehouse) Editions & Modules
—
Additional Pricing Details
—Google BigQuery
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Google BigQuery Editions & Modules
Edition
Queries (On-Demand) | $51 |
---|---|
Queries (Hourly Flex Slots) | $42 |
Queries (Monthly Flat Rate) | $20002 |
Queries (Annual Flat Rate) | $1,7002 |
- per TB
- per 100 slots