BigQuery Reviews

We are primarily using the solution to crunch data. Then, we are doing some ETL work on top of the data. 

We like that it is a serverless system. 

We can analyze terabytes of data in a very small amount of time. 

It's similar to a Hadoop cluster, except it's managed by Google.

The initial setup is simple.

We find the product to be very stable.

It scales quite well.

If they can provide any charting platform on top of this product, that would be ideal. BigQuery now only allows us to run queries. It doesn't provide us with any insights. For example, if a query took so many times, they could maybe provide any suggestions on how to optimize the queries or speed up the process. It would be helpful if they could provide some dashboards where you can easily view charts and information. That would be very useful.

I've been using the solution for two or three years. 

This is a highly stable product. There are no bugs or glitches. It doesn't crash or freeze. 

The solution is very scalable. 

Almost my entire team uses it. We have a 50-member team, and pretty much everyone is on it. They are mostly data engineers and developers. 

We have yet to reach out to technical support. We haven't had any issues. 

We chose this solution specifically since all of our services are in GCP, Google Cloud. Google Cloud has a basic internal coupling with BigQuery. That's the reason we are using BigQuery.

The initial setup is very easy. You just have to log in to the Google Cloud console, and then you can just create a few tables and start using it. 

From start to finish it takes about half an hour. It is even less than that to get the tables up and running. The deployment is quite fast.

I'm not sure about the exact cost, however, it is charged on the queries which you run, basically. For example, if you run a query, the amount of data scanned through BigQuery will dictate the costs. 

I am a customer and end-user.

I'm not sure which version of the solution we're using. 

It's a serverless platform deployed on a public cloud. 

I'd advise potential users to set up their tables accordingly. There are two sets of optimization that BigQuery provides as well. You set up whichever columns you want to do the partition and on which columns you want to do the clustering. If these columns are defined properly, then BigQuery's a breeze to use.

On a scale from one to ten, I would rate it at an eight. If they just added a few more features, it would be almost perfect.

BigQuery allows you to quickly analyze logs from your systems to identify the severity of issues. It integrates well with other Google Cloud services, such as Cloud Logging, where you can easily manipulate various data types and analyze all logs.

BigQuery excels at data analysis. It processes vast amounts of information using its advanced architecture and sophisticated querying capabilities, making it crucial for critical insights and safe for handling sensitive data. 

BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses.

I have been using BigQuery for two years.

I have opted for Fireye, Elasticsearch, and Alcon. One principal difference is that BigQuery starts with machine learning and WAN implementations, while you can implement VMware or other active boxes. Therefore, it is recommended that cloud VMs be used for BigQuery processes. You can execute jobs in the cloud, such as VMware.

For instance, you can compute analytics for email, apply filters, and manipulate weather data. It provides higher efficiency, though exact benchmarks are unclear. Additionally, starting the query flow login request can also be advantageous.

The initial setup is automatic. It requires one person. You need to log in to the Google Cloud platform, import the necessary package into your query, and then you can start querying your data. 

If you need a solid CRM solution integrated with Azure, you'll need knowledgeable people to support it. Three individuals can form a strong CRM team connected to Azure, leveraging BigQuery.

You can use BigQuery to generate and manage large datasets efficiently. Whether using a flexible integrated environment like Dataflow or a local studio, BigQuery provides powerful tools for querying and analyzing data.

The product is free of cost.

Setting up BigQuery on GCP is crucial. When creating a service account, you define the permissions required for project identification or access monitoring systems.

You configure policies using IAM roles to manage access permissions effectively within GCP. These roles govern the service accounts created for specific tasks such as data processing, system monitoring, or other service integrations. When you activate these policies, a JSON token is generated. This token can authenticate and authorize access to Google services like BigQuery or other third-party applications.

Moreover, by configuring VMs to match data processing requirements, you ensure that the data is securely handled by the applications associated with the service accounts. This setup enables seamless communication between your applications and Google services, facilitating efficient data acquisition and processing.

Overall, I rate the solution a seven out of ten.

I usually need to catalog. In my case, it's more related to data governance. I need to catalog information from BigQuery. I want to ensure the data quality tool is in sync with BigQuery, so I go to BigQuery and do queries to make sure it was synced with Atlan, for example, for data quality tools. I create validation rules and need to write the rule in BigQuery to create a query there, see how long it takes to run, and evaluate its performance in a data quality tool.

What I have seen is that they are using BigQuery as a central repository. They bring dispersed information to BigQuery, which facilitates exploring the data and gaining insights. Consequently, it improves operations, response time, and the business overall.

As a user, I have liked using BigQuery to create queries. They have a table explorer feature that allows you to select a table, choose fields, and generate queries easily, which significantly facilitates my workflow. I also appreciate the lineage feature, which shows how tables relate to each other and enables end-to-end usage visualization. 

Furthermore, its integration with other tools like Atlan through a Google Chrome extension is highly beneficial. Using BigQuery's central repository brings dispersed information together, which facilitates exploring the data and gaining insights. Consequently, it improves operations, response time, and the business overall.

There are integration challenges, particularly with performance when exporting data to BigQuery from other tools like Qualitics. It can be slower and more problematic compared to other platforms such as Snowflake.

I have been working with BigQuery for one year.

I have not seen a lot of problems, so I would say BigQuery is quite stable.

In my opinion, BigQuery is very scalable yet has some limitations regarding performance that are not always as required.

I don't have direct contact with BigQuery's support team. Our organization manages this through internal communication, and I contact my company’s team when issues arise.

Positive

I would recommend using BigQuery because it's a very good tool, easy to manage, and similar to other databases. Those familiar with SQL Server or Oracle can adapt to BigQuery easily. It's a scalable cloud solution. 

Overall, I would rate BigQuery as nine out of ten.

It is a pivotal component in enterprise data architecture, and crucial in data lake operations, whether supporting data warehouses or functioning as part of a broader data lake ecosystem.

One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions. Its unique architecture not only provides robust enterprise data warehouse capabilities but also seamlessly integrates with data lake functionalities.

The main challenges are in the areas of performance and cost optimizations. Achieving optimal results demands a certain level of familiarity with the platform's internals. The key point for improvement lies in the performance optimization.

I have been working with it for three months.

It exhibits a high level of stability and security, there are no notable issues in these aspects. I would rate it nine out of ten.

It is designed to seamlessly scale with the growing demands of data processing, there are no issues with it. I would rate it nine out of ten.

The technical support is commendable. However, there is room for improvement in the availability of resources and documentation from a technological standpoint. I would rate it seven out of ten.

Neutral

In the landscape of enterprise data warehouses, BigQuery stands out as a superior choice when compared to alternatives like Azure Synapse, AWS Redshift, and Snowflake. While Snowflake is known for its higher costs, and Redshift is perceived as both complex and expensive, Azure Synapse presents its own set of constraints with its MPP architecture and reliance on an RDBMS in-between. BigQuery, on the other hand, has a distinct edge with its seamless migration process, vast capabilities, and a harmonious balance of storage, computing, cost-effectiveness, and performance efficiency. This is particularly evident as organizations and professionals, including myself, have experienced ease in migrating from other vendors to BigQuery. Drawing from my extensive experience working across various cloud platforms such as AWS, Azure, and Snowflake, BigQuery consistently emerges as a robust and preferable solution.

The initial setup is straightforward.

Its cost structure operates on a pay-as-you-go model. I would rate it seven out of ten.

Whether for small, medium, or large enterprises, it is a recommendable choice. Its pricing model makes it accessible and manageable based on your usage. Given that many individuals and businesses already have Gmail accounts and utilize Google Cloud workspaces, incorporating BigQuery into operations is seamless. Moreover, a complimentary reporting tool, Looker Studio, is available for free, enhancing the reporting capabilities on BigQuery or via Google Sheets. Overall, I would rate it eight out of ten.

We use BigQuery to perform data warehouse migration for clients willing to move to GCP from their on-premise solution.

The solution's pricing is really competitive compared to other peers. The most valuable features of BigQuery is that it supports standard SQL and provides good performance.

I have been using BigQuery for three years.

I rate BigQuery a nine out of ten for stability.

Around 30 to 40 users use BigQuery in our organization.

I rate BigQuery ten out of ten for scalability.

I previously worked with Microsoft SQL Server.

The solution’s initial setup is very easy. You just have to spin up a data set and start using it.

I rate BigQuery ten out of ten for the ease of its initial setup.

The solution can be deployed by one person in a few minutes.

The solution's pricing is cheaper compared to other solutions. On a scale from one to ten, where one is cheap, and ten is expensive, I rate the solution's pricing a two or three out of ten.

Potential users can trust BigQuery without any second thoughts. The solution's pricing is great compared to other solutions. The solution provides more flexibility and supports standard SQL, and anyone coming out from a different platform would not face any challenges adopting BigQuery.

Overall, I rate BigQuery a nine out of ten.

We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect.

Everything they advertised or listed worked exactly as promised. That was advantageous to us. 

In future releases, I would like to see more pre-defined aggregated forms. After using BigQuery, we need to use the data in an enterprise architecture dimensional data model. So, having pre-defined aggregated forms would be helpful. 

Additionally, I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in.

I have experience with BigQuery. 

When I joined the company, BigQuery was already implemented by our team.

It is a cheap solution. 

I would recommend getting a clear understanding of BigQuery's functionalities and what it's best suited for. If your needs align with its capabilities, then you should definitely proceed. 

BigQuery offers fantastic features, but it's important to understand its purpose beforehand. Otherwise, you might face difficulties later on.

Overall, I would rate the solution an eight out of ten.

My company uses BigQuery as a data warehouse.

What I like most about BigQuery is that it's fast and flexible.

Another advantage of BigQuery is that it's easy to learn.

You can also use it from anywhere.

An area for improvement in BigQuery is its UI because it's not working very well.

Pricing for the solution is also very high.

In general, though, I like the solution very much.

I've been using BigQuery for six months now.

I found BigQuery stable in my six months of using it, and I'd rate its stability as ten out of ten.

BigQuery is a scalable solution, and it's a nine out of ten in terms of scalability.

I've never interacted with BigQuery support.

We used Redshift as a database for our operations, but now, we've moved to BigQuery because BigQuery is much more than a database. It has more features than Redshift, and we hope to pay less than what we paid when we were using Redshift because Redshift required us to pay ahead each month, and the total cost was too much.

BigQuery was easy to set up, but you'll need to learn how to do it. In general, the initial setup is straightforward.

I'd rate the BigQuery setup as eight out of ten.

Our in-house team implemented BigQuery for the company.

BigQuery pricing can increase quickly. It's a high-priced solution.

It would help if you researched how to reduce the price. It would take some time to find out how to set up BigQuery in a way that reduces its pricing.

My company is using a data warehouse solution called BigQuery.

My advice to anyone deciding on using BigQuery is to be aware of the pricing mechanism and have a better understanding of it to avoid surprises. You pay for what you use, so it could be very easy to lose control, which means the BigQuery costs could go up fast.

I'd rate BigQuery as nine out of ten.

BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights.

The product's most valuable feature is its ability to connect to visualization tools. 

Some of the queries are complex and difficult to understand. 

I have been using the product for more than a year. 

My company has 100 users for BigQuery. 

The tool's support is fast to respond. 

Positive

The tool's deployment is easy if you follow Google's documentation. 

If you have a big database and lots of analytics, BigQuery is a really good tool. It helps save and manage your queries and gives you results you can show clients and others. I rate it a nine out of ten.