Azure Synapse Analytics (Azure SQL Data Warehouse)
32 Ratings
Google BigQuery
173 Ratings

Azure Synapse Analytics (Azure SQL Data Warehouse)

32 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

Based on 32 reviews and ratings

Google BigQuery

173 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Based on 173 reviews and ratings

Feature Set Ratings

    Database-as-a-Service

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    9.2

    Google BigQuery

    92%
    Google BigQuery ranks higher in 6/6 features
    Google BigQuery ranks higher in 6/6 features

    Automatic software patching

    N/A
    0 Ratings
    9.2
    92%
    17 Ratings

    Database scalability

    N/A
    0 Ratings
    9.8
    98%
    29 Ratings

    Automated backups

    N/A
    0 Ratings
    9.4
    94%
    24 Ratings

    Database security provisions

    N/A
    0 Ratings
    9.2
    92%
    24 Ratings

    Monitoring and metrics

    N/A
    0 Ratings
    8.3
    83%
    25 Ratings

    Automatic host deployment

    N/A
    0 Ratings
    9.2
    92%
    14 Ratings

    Attribute Ratings

    • Google BigQuery is rated higher in 2 areas: Likelihood to Recommend, Support Rating
    • Azure Synapse Analytics (Azure SQL Data Warehouse) and Google BigQuery are tied in 2 areas: Usability, Contract Terms and Pricing Model

    Likelihood to Recommend

    8.8

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    88%
    8 Ratings
    9.6

    Google BigQuery

    96%
    29 Ratings

    Usability

    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings
    9.5

    Google BigQuery

    95%
    3 Ratings

    Support Rating

    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings
    9.6

    Google BigQuery

    96%
    18 Ratings

    Contract Terms and Pricing Model

    10.0

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    100%
    1 Rating
    10.0

    Google BigQuery

    100%
    1 Rating

    Professional Services

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    N/A
    0 Ratings
    8.5

    Google BigQuery

    85%
    2 Ratings

    Likelihood to Recommend

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    In terms of a well-suited scenario - the Azure Synapse can be used to capture data from multiple sources (especially from onPrem sources apart from Dataverse) and update the transformed data based on the given conditions (eg: refresh data based on the specified date/time ranges). Also, the transformed data can simply be transferred to Azure Data Lake for further processing by utilizing other analytics tools such as PowerBI.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Google BigQuery

    If you are using Google suites like Analytics 360, Big Query can be a very useful tool for storing & querying your data because of its seem less integration within Google environment. Also if your organisation has large set of data and you want fast data processing, then only it makes sense to move to Google BigQuery otherwise there are cheaper alternatives available.

    Read full review

    Sameera Srivastava | TrustRadius Reviewer
    Sameera Srivastava
    View all 29 answers on this topic

    Pros

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
    • Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
    • Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Google BigQuery

    • Huge plus point if you have idea running SQL scripts.
    • The ability to store and manage multiple data warehouses is a big plus point which helps a lot for growing businesses.
    • Easy integration with tools like Data Studio and Google Analytics which provides great data warehouse and data management solutions.

    Read full review

    Rounak Verma | TrustRadius Reviewer
    Rounak Verma
    View all 29 answers on this topic

    Cons

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
    • Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
    • Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Google BigQuery

    • One issue with Google Cloud Storage is its price. For one to have that premium Google Cloud Storage, for the purpose of massive storage, he/she must have adequate cash. Otherwise, Google Cloud Storage is a safe and perfect online storage platform.
    • The only thing that can come to mind that would be annoying with this software was that sometimes when trying to share files on the Cloud with coworkers, it would just not share at all, or there would be a massive delay in when I shared them and when they received them. Other than that though, everything is perfect with this.

    Read full review

    Sam Lepak | TrustRadius Reviewer
    Sam Lepak
    View all 29 answers on this topic

    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

    Starting Price

    —

    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

    Starting Price

    $4 per 100 slots

    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
    1. per TB
    2. per 100 slots
    Additional Pricing Details
    —

    Usability

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
    Based on 2 answers
    The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    Google BigQuery

    Google BigQuery 9.5
    Based on 3 answers
    web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2

    Read full review

    Richard Atkins | TrustRadius Reviewer
    Richard Atkins
    View all 3 answers on this topic

    Support Rating

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
    Based on 2 answers
    Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    Google BigQuery

    Google BigQuery 9.6
    Based on 18 answers
    BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.

    Read full review

    Tristan Dobbs | TrustRadius Reviewer
    Tristan Dobbs
    View all 18 answers on this topic

    Alternatives Considered

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.

    Read full review

    Samir Patel, PMP | TrustRadius Reviewer
    Samir Patel, PMP
    View all 8 answers on this topic

    Google 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.

    Read full review

    Csaba Toth | TrustRadius Reviewer
    Csaba Toth
    View all 29 answers on this topic

    Contract Terms and Pricing Model

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 10.0
    Based on 1 answer
    Basically, the billing is predictable, and this all about it.

    Read full review

    Vladimír Mužný | TrustRadius Reviewer
    Vladimír Mužný
    View all 1 answers on this topic

    Google BigQuery

    Google BigQuery 10.0
    Based on 1 answer
    None so far. Very satisfied with the transparency on contract terms and pricing model.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    Professional Services

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    No score
    No answers yet
    No answers on this topic

    Google BigQuery

    Google BigQuery 8.5
    Based on 2 answers
    Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    Return on Investment

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Azure Synapse has predominately reduced the time being used for processing data being extracted from multiple sources
    • Ability to integrate multiple data sources and create a single dataset that could be used for further analytics to find KPIs

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    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.

    Read full review

    Alex Andrews | TrustRadius Reviewer
    Alex Andrews
    View all 29 answers on this topic

    Add comparison