TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    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)

    Snowflake

    Score8.9 out of 10
    N/AThe Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.N/A
    Pricing
    Google BigQuerySnowflake
    Editions & Modules
    Standard edition
    $0.04 / slot hour
    Enterprise edition
    $0.06 / slot hour
    Enterprise Plus edition
    $0.10 / slot hour
    No answers on this topic
    Offerings
    Pricing Offerings
    Google BigQuerySnowflake
    Free Trial
    YesYes
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Google BigQuerySnowflake
    Considered Both Products
    Google
    Chose Google BigQuery
    We actually use Snowflake and BigQuery in tandem because they both currently meet various needs. Redshift, however, has barely been used since our migration away from it. In the case of both Snowflake and BigQuery, they beat Redshift by a long shot. The main reasons are their …
    Incentivized
    Chose Google BigQuery
    Google BigQuery is cheaper and much faster as compared to both. While as compared to Snowflake , we tested it was faster and cheaper by 30%, that is after Snowflake tweaked their environment, if not for that it would have been 90% cheaper than Snowflake. Redshift is not easy …
    Incentivized
    Chose Google BigQuery
    Google BigQuery is less expensive to run and offers free storage of up to the first 10 GB of data. Google BigQuery is also easier (and faster) to get up and running. Unlike Snowflake, Google BigQuery does not require any manual scaling or performance tuning. Scaling is …
    Incentivized
    Chose Google BigQuery
    I have used Snowflake and DataGrip for data retrieval as well as Google BigQuery and can say that all these tools compete for head to head. It is very difficult to say which is better than the other but some features provided by Google BigQuery give it an edge over the others. …
    Incentivized
    Chose Google BigQuery
    Fully serverless. We don’t manage clusters or warehouses. Requires us to manage virtual warehouses. BigQuery is cheaper for exploratory heavy queries; Snowflake is more predictable for sustained workloads. BigQuery is unbeatable if you’re deep in Google’s ecosystem; Snowflake …
    Incentivized
    Chose Google BigQuery
    Compared to every other analytics DB solution I've used, Google BigQuery was by far the easiest to set up and maintain, and scale.
    The price was also much lower for our use case (internal data analysis).
    Incentivized
    Chose Google BigQuery
    First and foremost, Google BigQuery's pricing structure, based on data processing and storage, is more cost-effective for our needs. Secondly, since we already use other Google Cloud services, its tight integration with them especially, with Cloud Storage and Dataflow was a big …
    Incentivized
    Chose Google BigQuery
    We based our analysis primarily on [BigQuery vs. Redshift vs. Athena] and BigQuery proved to be the best solution for us.
    Incentivized
    Chose Google BigQuery
    At my previous organization we used server based SQL server. There were days when the server was down and we couldn't work or access the data. This caused multiple reports and processes which were fed from the server to fail. Google BigQuery doesn't have such problems.
    Incentivized
    Chose Google BigQuery
    Both BigQuery and Redshift are two comparable fully managed petabyte-scale cloud data warehouses. They’re similar in many ways, but you should consider their unique features and how they can contribute to an organization’s data analytics infrastructure. When considering which …
    Incentivized
    Chose Google BigQuery
    BigQuery by far the best solution in all angles compared to other ones: Especially scalability, ease of use, performance and there is no need to manage any cluster of servers. Also it's ABSOLUTELY pay as you go! No one in market currently provide such service that can compete …
    Incentivized
    Chose Google BigQuery
    Google BigQuery of course collects a much much larger array of raw data and can handle (practically) an unlimited amount of data. For a large enterprise like ours that relies on large-scale analytics, this is absolutely imperative. Google BigQuery can also combine GA4 data with …
    Incentivized
    Snowflake Computing
    Chose Snowflake
    These are comparable products that can make sense depending on the specific needs of your organization. All are certainly serviceable and have varying pros and cons. Snowflake seems to provide the greatest degree of flexibility and easy scalability as new data gets brought into …
    Incentivized
    Chose Snowflake
    Snowflake has an attractive pricing model with auto-suspend and auto-resume and pay per use. AWS Redshift requires higher administrative efforts to maintain and scale the platform whereas with Snowflake those admin tasks are not needed or automatically taken care of.
    Incentivized
    Chose Snowflake
    We particularly liked Snowflake's security model as well as its unique storage (whereby everything is essentially a pointer to immutable micro-partitions, which is the key behind its zero-copy cloning, its secure sharing, its time travel, etc.). and also how it separates …
    Incentivized
    Chose Snowflake
    Each of the other solutions were cloud vendor specific, Snowflake can ride on either Amazon Web Services, Microsoft Azure, or Google Cloud. The fact that they are ANSI-sql compliant and have an effective means of offloading data makes them portable and easy to sell to teams …
    Incentivized
    Chose Snowflake
    Snowflake has won the match because it is giving an excellent performance with its efficient features and reliable results. This is a totally secure program for our precious and important data.
    Incentivized
    Chose Snowflake
    Snowflake beats these other products in every category it was rated against
    Incentivized
    Chose Snowflake
    In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best …
    Incentivized
    Chose Snowflake
    Our issue with Redshift was that it was very expensive. On top of that, queries were still slow and if we used more of Redshift's memory, then it would have cost even more. Snowflake is not cheap, but less costly for us. Plus, the performance was much better. Also, we got to …
    Incentivized
    Chose Snowflake
    More flexible and faster compared to Redshift, more functionality compared to BigQuery e.g. - per minute billing, instant spin up of warehouse. Overall, the cost and time savings swayed us in favor of Snowflake.
    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
    Google BigQuerySnowflake
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Google BigQuery and Snowflake
    Feature
    Google BigQuery
    8.4
    71 Ratings
    Snowflake
    -
    Ratings
    Automatic software patching8.017 Ratings00 Ratings
    Database scalability9.270 Ratings00 Ratings
    Automated backups8.524 Ratings00 Ratings
    Database security provisions8.664 Ratings00 Ratings
    Monitoring and metrics8.066 Ratings00 Ratings
    Automatic host deployment8.013 Ratings00 Ratings
    User Ratings
    Google BigQuerySnowflake
    Likelihood to Recommend
    8.5
    (71 ratings)
    9.2
    (43 ratings)
    Likelihood to Renew
    8.1
    (3 ratings)
    10.0
    (2 ratings)
    Usability
    7.7
    (5 ratings)
    9.3
    (19 ratings)
    Support Rating
    7.3
    (10 ratings)
    9.9
    (8 ratings)
    Contract Terms and Pricing Model
    10.0
    (1 ratings)
    8.0
    (1 ratings)
    Professional Services
    8.2
    (2 ratings)
    -
    (0 ratings)