What is Google BigQuery

Advantages

Sharing datasets

Different divisions of your company can store their datasets in BigQuery and easily share them with other divisions of the company and even with partner organisations.

Ability to perform federated queries

BigQuery separates calculations from storage, so BigQuery SQL queries can be run on files in CSV format (as well as JSON and Avro), which are stored in their original form in Google Cloud Storage.

Effective analytics

BigQuery allows you to use a wide range of tools business intelligence, such as Tableau, Looker and Looker Studio, for the implementation of various types of analysis, visual diagrams and calculations based on data stored in BigQuery.

Storage of data of different types

BigQuery can store a variety of data: numeric and text data, as well as geo spatial and hierarchical data.

Ease of controls

You don’t have to deal with administration databases and perform tasks, such as replication, defragmentation, or disaster recovery. BigQuery takes care of all this.

Safety

Data in BigQuery automatically is encrypted both during storage and during transmission. You can share your datasets with Google Cloud Identity and Access Management.