Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Google BigQuery
Score 8.6 out of 10
N/A
Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
$0
per month
Snowflake
Score 9.0 out of 10
N/A
The 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 BigQuery
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. …
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 …
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 …
Chose Google BigQuery
We based our analysis primarily on [BigQuery vs. Redshift vs. Athena] and BigQuery proved to be the best solution for us.
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.
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 …
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 …
Snowflake
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 …
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 …
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.
Chose Snowflake
Snowflake beats these other products in every category it was rated against
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 …
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 …
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.
Top Pros
Top Cons
Features
Google BigQuerySnowflake
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Google BigQuery
8.5
51 Ratings
3% below category average
Snowflake
-
Ratings
Automatic software patching8.117 Ratings00 Ratings
Database scalability8.851 Ratings00 Ratings
Automated backups8.524 Ratings00 Ratings
Database security provisions8.844 Ratings00 Ratings
Monitoring and metrics8.546 Ratings00 Ratings
Automatic host deployment8.113 Ratings00 Ratings
Best Alternatives
Google BigQuerySnowflake
Small Businesses
SingleStore
SingleStore
Score 9.7 out of 10
Google BigQuery
Google BigQuery
Score 8.6 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.7 out of 10
Db2
Db2
Score 8.7 out of 10
Enterprises
SingleStore
SingleStore
Score 9.7 out of 10
Db2
Db2
Score 8.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Google BigQuerySnowflake
Likelihood to Recommend
8.6
(51 ratings)
9.3
(37 ratings)
Likelihood to Renew
7.0
(1 ratings)
10.0
(2 ratings)
Usability
9.4
(3 ratings)
8.7
(13 ratings)
Support Rating
10.0
(9 ratings)
9.7
(8 ratings)
Contract Terms and Pricing Model
10.0
(1 ratings)
8.0
(1 ratings)
Professional Services
8.2
(2 ratings)
-
(0 ratings)
User Testimonials
Google BigQuerySnowflake
Likelihood to Recommend
Google
For organizations looking to avoid the overhead of managing infrastructure, BigQuery's server-less architecture allows teams to focus on analyzing data without worrying about server maintenance or capacity planning. Small projects or startups with limited data analysis needs and tight budgets might find other solutions more cost-effective. Also, it is not suitable for OLTP systems.
Read full review
Snowflake Computing
I am over our HR data, and we use Workday for our HR management system. I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket. Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform.
Read full review
Pros
Google
  • Its serverless architecture and underlying Dremel technology are incredibly fast even on complex datasets. I can get answers to my questions almost instantly, without waiting hours for traditional data warehouses to churn through the data.
  • Previously, our data was scattered across various databases and spreadsheets and getting a holistic view was pretty difficult. Google BigQuery acts as a central repository and consolidates everything in one place to join data sets and find hidden patterns.
  • Running reports on our old systems used to take forever. Google BigQuery's crazy fast query speed lets us get insights from massive datasets in seconds.
Read full review
Snowflake Computing
  • Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs
  • Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources
  • Snowflake manages concurrency better in our trials than other premium competitors
  • Snowflake has little to no setup and ramp up time
  • Snowflake offers online training for various employee types
Read full review
Cons
Google
  • Can't use it out of Google's cloud platform which is a minus point if you want a local setup.
  • Can be a little expensive to manage.
  • A little difficult to manage someone with less technical expertise as it requires you to have SQL knowledge of joins, CTEs etc.
Read full review
Snowflake Computing
  • This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team.
  • I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot.
Read full review
Likelihood to Renew
Google
We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.
Read full review
Snowflake Computing
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Read full review
Usability
Google
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
Snowflake Computing
The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Read full review
Support Rating
Google
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
Snowflake Computing
We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.
Read full review
Alternatives Considered
Google
Google's Firebase isn't a competitor but we had to use Google's BigQuery because Google's Firebase's database is limited compared to Google's BigQuery. Linking your Firebase project to BigQuery lets you access your raw, unsampled event data along with all of your parameters and user properties. Highly recommend connecting the two if you have a mobile app.
Read full review
Snowflake Computing
I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.
Read full review
Contract Terms and Pricing Model
Google
None so far. Very satisfied with the transparency on contract terms and pricing model.
Read full review
Snowflake Computing
No answers on this topic
Professional Services
Google
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
Snowflake Computing
No answers on this topic
Return on Investment
Google
  • 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
Snowflake Computing
  • Positive impact: we use Snowflake to track our subscription and payment charges, which we use for internal and investor reporting
  • Positive impact: 3 times faster query speed compared to Treasure Data means that answers to stakeholders can be delivered quicker by analysts
  • Positive impact: recommender systems now source their data from Snowflake rather than Spark clusters, improving development speed, and no longer require maintainence of Spark clusters.
Read full review
ScreenShots

Snowflake Screenshots

Screenshot of Snowflake Installation