Google BigQuery

What differentiates Google BigQuery from other similar products?

It offers links to BI tools like Looker or PowerBI among others, and it includes API interactions with various GCP tools. BigQuery effectively addresses the needs of many customers that want to create their data solutions while considering performance, usability, security, and cost.

What is your favorite aspect of this product?

We had a terrific experience with it. Because BigQuery is self-managed, it is highly straightforward to develop and build a data model without having to spend time allocating resources for every possible use case. Additionally, they provide a variety of price alternatives to meet diverse needs, protect data, and provide configuration options for appropriate governance.

What do you dislike most about this product?

After the table is built, more columns cannot be indexed. Once inserted, a row cannot be modified. Additionally, once the table is established, the table schema cannot be changed. Because of this, to add a new column, one must first create a new table, copy all of the existing columns, and then add the new column to the new table only.

What recommendations would you give to someone considering this product?

BigQuery is an effective solution that makes it simple and quick to use SQL to examine massive datasets. Because of how simple to use and how well it interfaces with other Google Cloud services, it is a tremendous asset for our company. I advise you to do this for excellent work.

What differentiates Google BigQuery from other similar products?

There isn't really anything that differentiates Google BigQuery from others other than maybe SQL syntax-specific quirks. The capabilities and features are on par with others,

What is your favorite aspect of this product?

Since BigQuery's page layout is similar to Redshift and Snowflake, it was an easy transition. In addition, it's very easy to create snapshots. In addition, it's very off-hands, meaning that resources and power can automatically be managed. Also, BigQuery lets you know how expensive a query is prior to running it.

What do you dislike most about this product?

While there isn't anything that I dislike, I think that the platform could do a better job in notifying users of changes that could be made to further optimize our use of BigQuery (whether it's writing queries better, organizing schemas better, and so on).

What recommendations would you give to someone considering this product?

BigQuery gets the job done just like any other competitor like Redshift or Snowflake. However, in rare situations where it matters, most people come from a background having used Redshift or Snowflake only, and therefore, when writing SQL, some things specific to BigQuery might take time getting used to. Other than that, I would take time to architect how you want the infrastructure to look prior to creating. However, if mistakes are made, they are easily correctable.

What differentiates Google BigQuery from other similar products?

The best option, which can save a ton of time, is offered by Google Cloud BigQuery, which also helps with building ML models using only SQL queries. The capability to import data from CSV and other sources is one of its outstanding features. We enjoy working with it.

What is your favorite aspect of this product?

Google Cloud BigQuery is among the most effective options for the data warehouse process. Because it is so easy to use, even a beginner can utilize the device in one sitting. The ability to build ML models using a query is one of its better features and one that I really liked. It makes it very simple to manage large and complex searches.

What do you dislike most about this product?

Bigquery bases its estimation of the cost of a query on the volume of data that has to be processed, hence, it is easy to make costly searches without recognizing it. The number of rows returned by the query will not change, even if I limit it. The new Bigquery SQL editor's autocomplete feature occasionally produces unwanted outcomes.

What recommendations would you give to someone considering this product?

It was first and foremost a fantastic tool that met all of our demands. For our employees, it makes it very easy to manage extensive and complicated searches, and one of its best features, and a feature I particularly like is the capability to build machine learning models using a query. I wish to suggest this to you on their behalf.