Avaliações do Google Cloud BigQuery

I like the serverless nature of BigQuery. It takes away most of the maintenance costs involved in maintaining and fine-tuning a data warehouse.

I didn't really like the on-demand pricing of BigQuery. Monthly costs tend to blow up excessively. I think they have a different pricing option now to resolve this though.

Our salesforce campaigns relies heavily on data warehouse, which is the backbone of everything we do. This data set contains both row data sets and BigQuery is used to aggregate this sets by running schedule queries on it.

This platform requires strong SQL skills. Huge dependency on tech team to fix queries sometime.

I use this tool in my first professionnal experience as Data Engineer and I still use it today. I used BigQuery for Datawarehouse : make data available for everyone (data analyst, developer...).
Today, I use it too for the logs of an ELT pipeline, it's still very simple to use this tool.

It's necessary to understand how costing works in detail, especially if you have a lot of data.

Ease of browsing through the data and seeing table structure

Not able to visualise data in BQ so had to export data or integrate visualisation tools

BigQuery is great at working with lots of data at a good price, especially when used with other Google Cloud tools

It can get messy when you're working with many different data sets at once, and changing existing data columns is hard.

It's cheap and very quick to process and query data directly.

It's bare-bones database, so doesn't come with analytical features or any visualisation or easy to use interface when compared to other solutions.

If you work with Google Stack in your company, using BigQuery makes sense. It's cloud, it's fast and it's easy to keep and update.

It's not so easy as some other tools. But in the other hand, it's part of Google Stack and you have easy information to get in the net.

The sandbox supports up to 4 ( I think) projects that you can work on for free. This is great for people who are just starting out and BigQuery is very affordable as a whole. The pre-installed datasets are convenient and also cover various topics.

The interface could be optimized. Currently loading up multiple datasets on the same project and / or opening multiple tabs for queries makes everything really confusing and hard to navigate .

There is a plethora of already available datasets on BigQuery. Most of them won't be related to topics that interest you but are still very useful. The UI is simple,there aren't any unnecessary features that can confuse you when it comes to using BigQuery. The program is 100% scale-able and can cover data in any size.

For some people it might be an issue that BigQuery is better suited to work alongside R and not Python.If you do not opt for a flat rate and end up having a large quantity of data to deal with, BigQuery can get pricey.

Can store large amount of data, cost effective and fast

At times takes time to process queries with large amount to data

Seamless integration with our data in G-sheets, Airtable, and other sources. Data visualizations / BI dashboards (using DS) at rock-bottom cost.

The number and type of data visualizations could be improved. Help system is not extensive (but with Stack Overflow, you'll be fine). The "stickiness" (persistence) and flexibility/customizability of filters needs work.

It's probably the best SQL tool I have ever used. Ultra-scalable. Big query does not care if your a making a query of 100 MB or of 1T. It super efficient.

The only one thing I would improve is the debugging. Sometimes when you make complex SQL queries, the debugging tool does not help a lot finding the problem.

full functionality and ease of connecting to BI tools and data sources. Easy connection to Sheets as a datasource is a specific plus

The pricing isn't consistent or straightforward and takes some time to understand. The pricing is fair and affordable but not obvious

Allow to import data in seconds from third party data sources, even there is an option to create multiple dashboards to visualize & analyses the data for marketing, sales purposes and so on depends on use cases.

Cost is very high with big data queries and also UI can be more improved specifically navigation and dragging options

I like the software because it is easy to use and have a good documentation to get started

It is expensive to use for smaller businesses

BQ was incredibly easy to set up and get going. As a beginner, the public data sets available also make practice very easy. There are a great many other softwires available in the Google Cloud that connect directly to BQ, so the whole system is set up to expand its usefulness without needing to buy more software.

I haven't run into anything about this software that I haven't liked so far. I have nothing negative to report.

We use Big Query for store the information of every client's CRM, its cheap and scalable

You will need a programmer to get the integration done properly, but is not too hard