TrustRadius: an HG Insights company

Azure Synapse Analytics vs. Google BigQuery

Save this comparison

Save this comparison

Azure Synapse Analytics

52 Reviews and Ratings

Google BigQuery

277 Reviews and Ratings

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure Synapse Analytics

    Score6.9 out of 10
    		N/AAzure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

    $4,700

    per month 5000 Synapse Commit Units (SCUs)

    Google BigQuery

    Score8.4 out of 10
    		N/AGoogle's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

    $6.25

    per TiB (after the 1st 1 TiB per month, which is free)

    Pricing
    Azure Synapse AnalyticsGoogle BigQuery
    Editions & Modules
    Tier 1
    $4,700
    per month 5,000 Synapse Commit Units (SCUs)
    Tier 2
    $9,200
    per month 10,000 Synapse Commit Units (SCUs)
    Tier 3
    $21,360
    per month 24,000 Synapse Commit Units (SCUs)
    Tier 4
    $50,400
    per month 60,000 Synapse Commit Units (SCUs)
    Tier 5
    $117,000
    per month 150,000 Synapse Commit Units (SCUs)
    Tier 6
    $259,200
    per month 360,000 Synapse Commit Units (SCUs)
    Standard edition
    $0.04 / slot hour
    Enterprise edition
    $0.06 / slot hour
    Enterprise Plus edition
    $0.10 / slot hour
    Offerings
    Pricing Offerings
    Azure Synapse AnalyticsGoogle BigQuery
    Free Trial
    NoYes
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Azure Synapse AnalyticsGoogle BigQuery
    Considered Both Products
    Microsoft
    Verified User
    Chose Azure Synapse Analytics
    In comparing Azure Synapse to the Google BigQuery - the biggest highlight that I'd like to bring forward is Azure Synapse SQL leverages a scale-out architecture in order to distribute computational processing of data across multiple nodes whereas Google BigQuery only takes into …
    Incentivized
    Paras Jasal
    Data Engineer in Engineering at Celebal Technologies (Computer Software, 1001-5000 employees)
    Chose Azure Synapse Analytics
    Synapse, in comparison has its ups and downs against the competitors. However, where it excels, and builds it's markets is the cheaper costs (compared to Redshift), low code platforms and an in house solution that does not need you to leave the Synapse workspace for end to end …
    Incentivized
    Google
    Jeeban Jyoti Das
    Lead Engineer in Engineering at Slk (Information Technology & Services, 1001-5000 employees)
    Chose Google BigQuery
    Google BigQuery is simpler and I say it has simpler UI too.
    If you have a clear long term ask , mainly business intelligence needs then Google BigQuery offers you good.
    If you need too much of features under a single cloud and you are ok to be lil clumsy then you can check …
    Incentivized
    Verified User
    Chose Google BigQuery
    Google BigQuery's main advantage over its direct competitors (Amazon Redshift and Azure Synapse) is that it is widely supported by non-Google software, while the others rely heavily on their own cloud ecosystems.
    Incentivized
    Verified User
    Chose Google BigQuery
    Google BigQuery i would say is better to use than AWS Redshift but not SQL products but this could be due to being more experience in Microsoft and AWS products. It would be really nice if it could use standard SQL server coding rather than having to learn another dialect of …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Azure Synapse AnalyticsGoogle BigQuery
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Azure Synapse Analytics and Google BigQuery
    Feature
    Azure Synapse Analytics
    -
    Ratings
    Google BigQuery
    8.4
    71 Ratings
    Automatic software patching00 Ratings8.017 Ratings
    Database scalability00 Ratings9.270 Ratings
    Automated backups00 Ratings8.524 Ratings
    Database security provisions00 Ratings8.664 Ratings
    Monitoring and metrics00 Ratings8.066 Ratings
    Automatic host deployment00 Ratings8.013 Ratings
    User Ratings
    Azure Synapse AnalyticsGoogle BigQuery
    Likelihood to Recommend
    8.1
    (9 ratings)
    8.5
    (71 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    8.1
    (3 ratings)
    Usability
    9.6
    (2 ratings)
    7.7
    (5 ratings)
    Support Rating
    9.6
    (2 ratings)
    7.3
    (10 ratings)
    Contract Terms and Pricing Model
    10.0
    (1 ratings)
    10.0
    (1 ratings)
    Professional Services
    -
    (0 ratings)
    8.2
    (2 ratings)