Data Warehouse
Icon_24px_BigQuery_Color
Google Cloud

GCP BigQuery

Implements Data Warehouse.

PaaS

BigQuery is Google Cloud's fully managed, serverless data warehouse built for fast SQL analytics over very large datasets. Its separation of storage and compute lets queries scale automatically without cluster management, and it can analyze petabytes in seconds. Built-in machine learning through BigQuery ML and streaming ingestion make it a comprehensive analytics platform.

Capabilities

  • Columnar storage for fast aggregation
  • Massively parallel query execution
  • Separate storage and compute scaling
  • Batch and streaming ingestion

Primitive

Data WarehouseThis component is an implementation of Data Warehouse. Visit the primitive to learn more about what purpose it serves.

Related services · Google Cloud

Icon_24px_SQL_ColorIcon_24px_SQL_Color
GCP SQL
Icon_24px_CloudStorage_Color
GCP GCS
Icon_24px_Monitoring_Color
GCP Monitoring

Alternatives

Icon-Architecture/64/Arch_Amazon-Redshift_64
AWS Redshift
AZ Synapse