What is Google BigQuery? What are the benefits of BigQuery for the data warehouse practitioners?

0 votes
Oct 7, 2019 in GCP by Karan
• 11,610 points
1,347 views

1 answer to this question.

0 votes

Google BigQuery is a replacement for the hardware setup for the traditional data warehouse.

It is used as a data warehouse and thus, acts as a collective store for all the analytical data in an organization. 

Also, the BigQuery organizes the data table into the units that are known as datasets.

Using BigQuery proves very useful for the data warehouse practitioners, here are some of them –

  • BigQuery allocated query resources and storage resources dynamically on the basis of requirement and usage. Thus, it doesn’t require the provisioning of resources before usage.

  • It has different data storage formats such as proprietary format, proprietary columnar format, query access pattern, Google’s distributed file system and others for efficient storage management.

  • It is a fully maintained and managed service.BigQuery architects deal with the updates and support of the administration completely with no downtime or block to the performance.

  • BigQuery provides backup recovery and disaster recovery at a broader level. Users can easily revert to previous changes without the need for back up and recovery.

answered Oct 7, 2019 by Sirajul
• 55,530 points

Related Questions In GCP

0 votes
2 answers
0 votes
1 answer

where is drop down menu for the google cloud platform

It is important that you are signed ...READ MORE

answered Sep 20, 2019 in GCP by Sirajul
• 55,530 points
138 views
0 votes
1 answer
0 votes
1 answer

What are the advantages of using gcp?

Google Cloud Platform is a medium that ...READ MORE

answered Oct 4, 2019 in GCP by Sirajul
• 55,530 points
349 views
0 votes
1 answer

Does Google cloud platform (GCP) offer IaaS ? Or just PaaS?

GCP provides IaaS as well, although it ...READ MORE

answered Sep 20, 2019 in GCP by Sirajul
• 55,530 points
1,183 views
0 votes
1 answer

How do I create a VPCN (Virtual private cloud network) on Google Cloud?

You can connect various GCP resources to each ...READ MORE

answered Sep 23, 2019 in GCP by Sirajul
• 55,530 points
254 views
0 votes
1 answer

Cloud SQL of google cloud is IaaS or PaaS?

Cloud SQL is PAAS (Plaform As A ...READ MORE

answered Sep 23, 2019 in GCP by Sirajul
• 55,530 points
588 views
0 votes
1 answer

What all services does Google Cloud provide as a part of machine learning?

Here's a list of  Machine learning services that ...READ MORE

answered Sep 23, 2019 in GCP by Sirajul
• 55,530 points
151 views
0 votes
1 answer
0 votes
1 answer