Google BigQuery

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.

What differentiates Google BigQuery from other similar products?

Google BigQuery is well-liked on the front end because it is cost-effective and easy to use, but when it comes to execution, it is an enterprise data warehouse that is totally serverless, has integrated ML and BI is cross-cloud compatible and expands with all of our business data. We can access and use our data wherever it is by using BigQuery, which eliminates the need for a separate repository to store data.

What is your favorite aspect of this product?

I was able to easily analyze data from the many clouds in a secure, quick, and convenient manner using the Google BigQuery platform, and I was able to disseminate only the outputs that were required and of high quality using a single user interface. With the help of this wonderful technology, we can now dramatically streamline our research, learn new things about spatial data, and build entirely new business potential.

What do you dislike most about this product?

The UI did not particularly appeal to me; in my opinion, it should be more understandable, simple to use, customizable, and logical. Except for it, the query quality is excellent and all other operations go without a hitch. I want to design our dashboards as rapidly as possible based on the needs that are currently a little overwhelming.

What recommendations would you give to someone considering this product?

BigQuery is a tool that can be helpful for massive data as its name implies. Since everything can be done inside the BigQuery Platform with a single touch, using manual ML models is no longer necessary to transform large amounts of raw data into profitable analytics. In contrast to competitors, it provides a less complex yet effective data analysis store that will help business expansion and earnings.