Google Cloud (GCP) Intermediate
GCP data services cheat sheet – which service when?
Storage
- Cloud Storage – files and data lake.
- BigQuery – serverless analytics warehouse.
- Bigtable – huge, low-latency key/value and time series.
- Spanner – globally consistent relational database.
- Cloud SQL / AlloyDB – managed MySQL/PostgreSQL.
Ingest & process
- Pub/Sub – event messaging.
- Dataflow – Apache Beam batch + streaming.
- Dataproc – managed Spark/Hadoop.
- Datastream – change data capture.
- Data Fusion – visual pipelines.
Orchestrate & transform
- Cloud Composer – managed Airflow.
- Dataform – SQL workflows in BigQuery.
- Workflows – lightweight service orchestration.
Govern & share
- Dataplex – catalog, quality, lineage, policies.
- Analytics Hub – share datasets without copying.
- Sensitive Data Protection – find and mask PII.
Analyse & ML
- Looker / Looker Studio – BI and dashboards.
- BigQuery ML – ML models in SQL.
- Vertex AI – end-to-end ML and generative AI platform.
Feedback & comments (1)
Divya Pillai
Perfect last-minute revision sheet.