Google BigQuery
Google BigQuery
Google BigQuery
Starting at $4 per 100 slots
View PricingOverview
What is Google BigQuery?
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.
Read moreRecent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
View all 6 features- Database scalability (30)9.494%
- Database security provisions (24)9.292%
- Automated backups (24)9.090%
- Monitoring and metrics (26)7.979%
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Google BigQuery, and make your voice heard!
Pricing
View all pricingQueries (Hourly Flex Slots)
$4
Cloud
per 100 slots
Queries (On-Demand)
$5
Cloud
per TB
Queries (Annual Flat Rate)
$1,700
Cloud
per 100 slots
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is Google BigQuery?
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.
Google BigQuery Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
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.
Reviewers rate Database scalability highest, with a score of 9.4.
The most common users of Google BigQuery are from Mid-sized Companies (51-1,000 employees).
Comparisons
View all alternativesCompare with
Reviews and Ratings
(202)
Attribute Ratings
Reviews
(1-25 of 31)- Popular Filters
Companies can't remove reviews or game the system. Here's why
December 21, 2022
One stop solution for data management and fast querying
- Automatically optimises queries to fetch data quickly
- Allows efficient management of data across multiple databases
- The editor and query builder have a very intuitive interface that makes it easy to build new queries fast
- Not able to search specific column fields using search functionality
- Uploading database using excel is time consuming and error prone
- The error message thrown while querying can be more customisable to correct the errors
- Speed of execution and data retrieval was excellent.
- Great customer support and online help if I got stuck.
- Data exploration and visualization capabilities were really handy, especially when using multiple data sources.
- Not as easy to use as other competitive softwares like Snowflake.
- Other cloud infrastructures like Microsoft Cloud and AWS aren't easily connected. This was hard while trying to merge with external data sources.
- Running ad hoc queries to get quick numbers isn't that easy with BigQuery.
December 20, 2022
Google BigQuery is a great tool for basic data warehousing.
- Inexpensive data storage.
- Relatively easy to use interface once you get used to it.
- Inexpensive query costs.
- Good number of native integrations.
- Difficult to use interface if you're not used to it.
- User management has proven confusing when trying to add new people to projects/accounts.
- There is no user support, which is a huge issue.
December 19, 2022
Google BigQuery is ok!
- Cloud based architecture rather than client based architecture
- There is a free trial
- Google product so the support is very good
- Most organizations use SQL so it is a bit of an adjustment
- No other major issues - serverless data is great and hard to frown upon
- Large queries run well in the program
May 05, 2022
Best Serverless SQL Database
- Data Warehousing
- Sporadic SQL queries without having to manage instances
- Reporting directly consumed from views
- A better output data exploration tool
- Better handling of parquet files
- An own application with a more comfortable UI than in the browser
December 13, 2021
Best scaled engineering/analytical data service available
Score 10 out of 10
Vetted Review
Verified User
- Standard SQL
- Scale
- RDBMS-like features
- Python library support
- Reliability
- Python library authentication simplification
- multi-transaction ACID compliance
November 04, 2021
Quit Worrying, Start Using BigQuery
Score 10 out of 10
Vetted Review
Verified User
- Transparency in terms of cost
- Utilisation of the data warehouse and suggestion on the sizes
- Easy to use and integration with other components
- UiUX features can be improved further in terms of navigating from one folder to another
- Reliable
- Fast
- Extremely powerfull
- Need more partitions than just dates
- Would like to chose which partition we insert into
Score 10 out of 10
Vetted Review
Verified User
- Google BigQuery is column based, therefore it has high speed and easily accessible.
- As I work with inventory related data, it gives me real time updates which helps to resolve many blocks which could cause problems if delayed.
- Being serverless, it is easy to handle large size data.
- Google BigQuery charge according to the quality of the code. So if it is long and lengthy and not the most efficient it can be costly.
- The UI/UX is little difficult to use at the beginning on a small screen because of the layout.
June 25, 2021
DataWarehousing with 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.
- 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.
April 26, 2021
BigQuery = Big Win
- Performance at scale.
- Console interface is a little clunky.
March 11, 2020
Querying TBs of data in seconds without any issues!
- Query performance is awesome.
- Fully managed.
- Can be used for all batch jobs or aggregations.
- Query pricing is still higher if we don't take flat pricing which is high.
- Storage pricing is also counted.
- It do not handle external dependencies.
February 28, 2020
Easily Managed Data Warehouse Delivered At Scale
- Highly scalable data warehouse
- Easily integrated into analytics tools like Data Studio
- Easy to use with SQL support
- Can be pricey. There are ways to lower costs but they aren't always straightforward.
January 18, 2020
THE tool you need to improve your business
- It provides a central data storage regardless of the data source.
- It features functionality that makes it easy to store and re-run queries.
- It can be overwhelming to non-technical users at first.
- You can easily get confused as to what to do to start if not familiarized with the workflow.
December 23, 2019
Big Advantages to BigQuery
- The computing used by BigQuery is dynamically distributed across compute resources so that you do not have to manage compute clusters.
- Big Query connects easily with Tableau so that you can analyze billions of rows in seconds using visual analysis tools without writing a single line of code.
- Although BigQuery machine learning gives you the option to control your geographic data, it only applies to the US, Asia, and Europe. Further expansion of this option to other parts of the world would be beneficial.
- You don’t need to install, provision, or set up anything with Big Query because it is managed. The downside being that you can’t use it outside of Google Cloud Platform.
December 20, 2019
Google BigQuery for analyzing large ML datasets using SQL
- It is easy to create and then execute machine learning models in BigQuery using SQL queries using BigQuery ML. Everyone knows SQL.
- Google BigQuery is fully serverless/cloud based and can be up and running in few hours without need for any specific coding or integration if your data is already is Google Storage.
- Google BigQuery executes the SQL statements very fast and can can be used for real-time analytics especially if you use Google infrastructure ( GCP).
- Google BigQuery is great for large data sets where you need a familiar SQL interface but it is still slower than running the same SQL query on RDBMS, assuming your data is mostly structured.
- It is expensive if you have a lot of data that needs to be queried each time the query is run due to the license metrics used in Google BigQuery.
- Some of the SQL operations like table join are not optimized and can be slow compared to a full database.
October 16, 2019
Google BigQuery is BIG for our company.
- BigQuery is ridiculously fast and has the ability to query absurdly large data sets to return results immediately.
- BigQuery allows for storage of a massive amount of data for relatively low prices.
- Easy to learn. BiqQuery uses SQL-like queries and is easy to transfer your existing skills to use.
- BigQuery can be dangerous. The charges can rack up quickly if you don't construct your queries properly. Traverse too much data too frequently and you can cost yourself some money.
August 12, 2019
BigQuery- A big tool with a lot to offer
- Cloud storage- always a huge draw for small businesses who may or may not have a bricks-and-mortar office to work from. We can share data easily and access it from anywhere.
- The user interface is excellent- easy to navigate and conduct whatever specific analyses you want
- You pay for the data you process, so it's kind of a pay-per-use system. This is awesome for smaller companies who may not need excessive amounts of data processed per month but still need the powerful analytics of a program like BigQuery.
- Even though the cost is pay-per-use, it's still expensive. This may make the program impractical for companies that won't use it frequently enough or for high-powered processing as it is meant for.
- Sometimes it is difficult to import data from alternate sources and manage it. The integrations between BQ and other online cloud storage aren't always a smooth transfer.
- 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.
- 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.
May 05, 2019
Dive Deeper into your Firebase Data
- Scalable.
- Love that it uses SQL.
- Low-cost.
- Easy integration with Firebase.
- UI/UX is a bit scary right away.
- Takes a strong learning curve to get used to.
February 26, 2019
Google BigQuery, Ideal for Large Companies with Multiple Teams
- BigQuery integrates well with other platforms, for instance, Knime and can be connected to other data visualization or manipulation programs.
- It is easy to use with multiple users and teams and creating areas for users of different levels or types is fairly easy to manage.
- Integrates well with Cloud and allows you to export large amounts of data.
- The user interface is easy to use and enables SQL and data querying similar to a database.
- Some of the SQL you can execute in a database is not exectuable in BigQuery which limits how much you can do right inside the platform. However, most of what you can do in a database is doable in BigQuery itself.
- Charting and other data visualization working with the data inside of BigQuery could be an improvement
- The legacy and non-legacy SQL was a little confusing and some of the SQL functions did not always allow us to do the things we wanted to do
February 15, 2019
Google BigQuery: Slow Learning Curve
- It is faster than the product we use for our websites, MySQL.
- Can query millions of rows within seconds and can give you the data very fast.
- Documentation should be detailed. I had a very hard time learning it. My seniors are also facing so many hurdles while using this.
- No proper flow is mentioned in the docs about how to use this product. We faced so many errors at different stages.
November 29, 2018
Analyze data at lightening speed @BigQuery
- Processing of huge volumes of data enabled us to provide strategic insights by understanding the facts and realities.
- Detailed Audience analysis enabled us to achieve better targeting for digital media and marketing campaigns
- Personalization: We are able to achieve personalization by marrying, stitching, and processing huge volume of data.
- SQL syntax is not exactly same as ANSI SQL so there is a learning curve. Traditional SQL queries cannot execute in BigQuery which limits portabiltiy of the code.
- Limitation on visualization: We can improve visualization in data studio by bringing in the ability to support complex functions/formulas such as Tableau can do.
November 21, 2017
Data Analysis on Steroids with Google Big Query
- Big Query is fast and based on the cloud you can run your query on a huge dataset. Huge means data in TB's. This also reduces the company cost to build that kind of infrastructure to store data.
- Not specific to Google Analytics but you can import data from different sources for analysis purpose and use the power of the cloud to run the query.
- Not much time to learn - You don't need any special skills, just SQL and you can use Big Query for your use. Learning SQL is not a big task you can learn it in a week.
- Big Query refrence schema and different sample query are available to practice on queries.
- Google also provide sample dataset to use then purchase Big Query.
- 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.
June 26, 2017
BigQuery is a game changer for OLAP
- BigQuery integrates exceptionally well with Google Storage. All you have to do is push a CSV to Google Storage, and add it to BQ. BQ will try to detect the schema and import the CSV as a table. The process is very quick.
- There are lots of ways to interact with BQ. Besides the web interface, there are also SDKs you can use to interface with bigquery from your tools. Meaning, it's not just data stuck in the cloud.
- BigQuery lets you search extremely large datasets, quickly. We have many 100m+ datasets loaded, and searching any number of fields through them is not only easy (SQL!) but fast as well (most queries finish < 30 seconds). It's not a real-time system, but for OLAP, it's unbeatable.
- It would be awesome to have BQ be real-time. Right now it serves the OLAP use case very well, but interactive would be great too.
- The user interface is not the best we've used.
- We'd love to have the Standard SQL mode be on by default.