Dataflow vs Dataproc – Streaming vs Batch

Google Cloud Dataflow vs Dataproc (Managed Service for Apache Spark)

📌 2025-2026 Update: Google Cloud has rebranded Dataproc to Managed Service for Apache Spark (formerly known as “Dataproc on Compute Engine” for cluster deployment and “Google Cloud Serverless for Apache Spark” for serverless deployment). The core functionality remains unchanged. Additionally, GCP AI Platform Training (Cloud ML Engine) has been superseded by Vertex AI, which is now part of the Gemini Enterprise Agent Platform.

Cloud Dataproc (Managed Service for Apache Spark)

  • Cloud Dataproc, now rebranded as Managed Service for Apache Spark, is a managed Spark and Hadoop service that lets you take advantage of open-source data tools for batch processing, querying, streaming, and machine learning.
  • Provides a Hadoop cluster on GCP with access to Hadoop-ecosystem tools (e.g., Apache Pig, Hive, and Spark); this has strong appeal if already familiar with Hadoop tools and have Hadoop jobs.
  • Ideal for Lift and Shift migration of existing Hadoop environment.
  • Offers two deployment modes:
    • Cluster deployment — managed Spark clusters on Compute Engine (you pay for cluster uptime)
    • Serverless deployment — Spark-jobs-as-a-service on fully managed Google Cloud infrastructure (you pay for job runtime only, zero cluster management)
  • Consider Dataproc (Managed Service for Apache Spark) when:
    • You have a substantial investment in Apache Spark or Hadoop on-premise and are considering moving to the cloud
    • You are looking at a Hybrid cloud and need portability across a private/multi-cloud environment
    • In the current environment, Spark is the primary machine learning tool and platform
    • The code depends on custom packages along with distributed computing needs
    • You need fine-grained cluster configuration, custom libraries, or specific Hadoop ecosystem tool versions

Key Features (2024-2026)

  • Lightning Engine — next-generation native C++ vectorized execution engine that delivers up to 4.9x faster performance than open-source Spark with zero code changes. Uses SIMD vectorization, intelligent caching, and optimized columnar shuffling. Available on the premium pricing tier.
  • Serverless Spark (Zero-Ops) — zero cluster management with intelligent autoscaling. Resources scale up and down automatically to match job needs, ensuring maximum performance and cost-efficiency without paying for idle time.
  • Enhanced Autoscaling — reduces cluster VM expenditures by up to 40% and cumulative job runtime by 10%.
  • BigQuery Integration — Serverless for Apache Spark is deeply integrated with the BigQuery unified data-to-AI platform, offering a unified developer experience in BigQuery Studio.
  • Vertex AI / Gemini Enterprise Agent Platform Integration — seamless interoperability for ML workflows.
  • Dataproc on GKE — run Spark workloads on Google Kubernetes Engine for containerized environments.

Cloud Dataflow

  • Google Cloud Dataflow is a fully managed, serverless service for unified stream and batch data processing at scale, based on the open-source Apache Beam SDK.
  • Scales to 4,000 workers per job and routinely processes petabytes of data with built-in autoscaling.
  • Ideal for new pipelines with minimal infrastructure management, event stream processing, and real-time analytics.
  • Consider Dataflow when:
    • Building new, greenfield data pipelines (no existing Spark/Hadoop code to migrate)
    • Requiring truly serverless, zero-ops data processing
    • Working with unified batch and streaming in a single pipeline
    • Using it as a pre-processing pipeline for ML models deployed in Vertex AI (Gemini Enterprise Agent Platform)
    • None of the above considerations made for Cloud Dataproc are relevant

Key Features (2024-2026)

  • Dataflow Prime — supports both horizontal autoscaling (more machines) and vertical autoscaling (larger machines) automatically for streaming and batch workloads.
  • AI/ML Integration (Dataflow ML) — RunInference API enables running ML models (PyTorch, TensorFlow, scikit-learn, ONNX, TensorRT) directly within Dataflow pipelines. MLTransform API for data preparation.
  • GPU Support — supports NVIDIA T4, L4, A100, H100, V100, and RTX Pro 6000 GPUs for ML inference workloads.
  • TPU Support — TPU V5E, V5P, and V6E for high-volume, low-latency ML inference at scale directly within Dataflow jobs.
  • Global Compute — dynamically schedules workloads across Google’s global infrastructure, automatically determining optimal location based on data locality and resource availability.
  • Streaming AI — build streaming AI with Gemini models and Gemma models, run remote inference, and streamline data processing.
⚠️ Deprecation Notice: Dataflow SQL was deprecated on July 31, 2024, and fully removed on January 31, 2025. Users should use BigQuery for SQL-based analytics instead.

Cloud Dataflow vs Dataproc — Key Differences

Criteria Dataflow Dataproc (Managed Service for Apache Spark)
Programming Model Apache Beam (Java, Python, Go) Apache Spark, Hadoop, Pig, Hive, Flink, Trino
Infrastructure Fully serverless, zero ops Managed clusters OR Serverless Spark
Cluster Management None (fully managed) User-managed (cluster) or None (serverless)
Best For New pipelines, streaming, minimal ops Existing Spark/Hadoop jobs, lift-and-shift
Streaming Native, unified batch + stream Spark Structured Streaming
ML/AI RunInference API, GPU/TPU support SparkML, Vertex AI integration
Scaling Auto (up to 4K workers), Global Compute Auto or manual, Lightning Engine (4.9x faster)
Code Changes Requires Apache Beam rewrite Minimal (run existing Spark/Hadoop code)

Cloud Dataflow vs Dataproc Decision Tree

Dataflow vs Dataproc

Dataflow vs Dataproc Table

GCP Certification Exam Practice Questions

  • Questions are collected from Internet and the answers are marked as per my knowledge and understanding (which might differ with yours).
  • GCP services are updated everyday and both the answers and questions might be outdated soon, so research accordingly.
  • GCP exam questions are not updated to keep up the pace with GCP updates, so even if the underlying feature has changed the question might not be updated
  • Open to further feedback, discussion and correction.
  1. Your company is forecasting a sharp increase in the number and size of Apache Spark and Hadoop jobs being run on your local data center. You want to utilize the cloud to help you scale this upcoming demand with the least amount of operations work and code change. Which product should you use?
    1. Google Cloud Dataflow
    2. Google Cloud Dataproc (Managed Service for Apache Spark)
    3. Google Compute Engine
    4. Google Kubernetes Engine
  2. A startup plans to use a data processing platform, which supports both batch and streaming applications. They would prefer to have a hands-off/serverless data processing platform to start with. Which GCP service is suited for them?
    1. Dataproc
    2. Dataprep
    3. Dataflow
    4. BigQuery
  3. A company has existing Apache Spark ML pipelines running on-premises and wants to migrate to Google Cloud with minimal code changes while achieving better performance. Which service should they use?
    1. Cloud Dataflow
    2. Managed Service for Apache Spark (Dataproc) with Lightning Engine
    3. BigQuery ML
    4. Vertex AI Training
  4. An organization needs to run real-time ML inference on streaming data with GPU acceleration in a fully serverless manner. Which GCP service best fits this requirement?
    1. Dataproc Serverless
    2. Google Cloud Dataflow with RunInference API
    3. Cloud Functions
    4. GKE with Spark Streaming
  5. A team wants to run Apache Spark batch jobs without managing any infrastructure and wants to pay only for the time their jobs are running. Which deployment option should they choose?
    1. Dataproc Cluster deployment
    2. Managed Service for Apache Spark – Serverless deployment
    3. Cloud Dataflow
    4. Compute Engine with Spark installed

Frequently Asked Questions

What is the difference between Dataflow and Dataproc?

Dataflow is a fully managed serverless stream/batch processing service based on Apache Beam. Dataproc (now Managed Service for Apache Spark) is a managed Hadoop/Spark cluster for lift-and-shift big data workloads.

When should I use Dataproc instead of Dataflow?

Use Dataproc when you have existing Spark/Hadoop code to migrate, need specific Hadoop ecosystem tools (Hive, Pig, Presto), or want fine-grained cluster control. Use Dataflow for new pipelines or unified stream+batch processing.

Is Dataflow serverless?

Yes, Dataflow is fully serverless — it automatically provisions, manages, and scales workers based on workload. You only pay for resources consumed during pipeline execution with no idle cluster costs.

Related Posts

References

Google Cloud Dataproc – Managed Spark & Hadoop

🔄 SERVICE REBRANDED — Now “Managed Service for Apache Spark”

Google Cloud Dataproc has been renamed to “Managed Service for Apache Spark” (2026).

The rebrand unifies the former “Dataproc on Compute Engine” (cluster deployment) and “Google Cloud Serverless for Apache Spark” (serverless deployment) under a single umbrella. The gcloud dataproc CLI commands and console URLs remain functional, but documentation now uses the new name.

This post uses the original “Dataproc” name for continuity, as the service functionality remains identical.

Google Cloud Dataproc (Managed Service for Apache Spark)

  • Cloud Dataproc is a managed Spark and Hadoop service that lets you take advantage of open-source data tools for batch processing, querying, streaming, and machine learning.
  • Dataproc automation helps to create clusters quickly, manage them easily, and save money by turning clusters on and off as needed.
  • Dataproc helps reduce time and money spent on administration and lets you focus on your jobs and your data.
  • Dataproc clusters are quick to start, scale, and shutdown, with each of these operations taking 90 seconds or less, on average.
  • Dataproc has built-in integration with other GCP services, such as BigQuery, Cloud Storage, Bigtable, Cloud Logging, and Monitoring.
  • Dataproc clusters support Spot VMs (previously called preemptible instances) that have lower compute prices to reduce costs further.
  • Dataproc supports connectors for BigQuery, Bigtable, Cloud Storage, and Cloud Spanner.
  • Dataproc supports Anaconda, HBase, Flink, Hive WebHCat, Druid, Jupyter, Presto, Trino, Solr, Zeppelin, Ranger, Zookeeper, Delta Lake, Iceberg, Hudi, and much more as optional components.
  • Dataproc offers two deployment modes:
    • Cluster Deployment (Dataproc on Compute Engine) — Spark-clusters-as-a-service; you manage infrastructure configuration and pay for cluster uptime.
    • Serverless Deployment (Serverless for Apache Spark) — Spark-jobs-as-a-service; fully managed Google Cloud infrastructure with pay-per-job-runtime billing.

Dataproc Serverless for Apache Spark

  • Dataproc Serverless lets you run Spark workloads without provisioning or managing a cluster.
  • Serverless supports two workload types:
    • Batch Workloads — Submit PySpark, Spark SQL, SparkR, or Spark (Java/Scala) batch jobs. Resources are auto-scaled and charges apply only during execution.
    • Interactive Sessions — Write and run code in Jupyter notebooks or BigQuery Studio notebooks via Spark Connect.
  • Serverless uses Dynamic Resource Allocation for autoscaling (not YARN-based).
  • Supports scheduling via Cloud Composer (Airflow) or Cloud Scheduler.
  • Offers Standard and Premium tiers:
    • Standard Tier — Core batch execution with autoscaling.
    • Premium Tier — Adds Lightning Engine, Native Query Execution, interactive sessions, and Gemini-powered autotuning.
  • Supports custom container images, GPUs, and VPC Service Controls.

Dataproc Lightning Engine

  • Lightning Engine is a next-generation performance layer that accelerates Spark workloads up to 4.9x faster than open-source Apache Spark with zero code changes.
  • Available for both cluster and serverless deployments.
  • Key components:
    • Native Query Execution (NQE) — A C++ vectorized execution engine built on Velox and Apache Gluten that bypasses JVM bottlenecks.
    • Intelligent Caching — Automatically caches frequently accessed data for faster reads.
    • Optimized Columnar Shuffling — Reduces shuffle overhead for large joins and aggregations.
  • Enabled by specifying --engine=lightning during cluster creation or selecting the Premium tier for serverless workloads.
  • Does not require any application code changes to existing Spark jobs.

Dataproc Cluster High Availability

  • Dataproc cluster can be configured for High Availability by specifying the number of master instances in the cluster.
  • Dataproc supports the following cluster configurations:
    • Single Node Cluster — 1 master, 0 Workers (default, non-HA)
      • Provides one node for both master and worker.
      • If the master fails, in-flight jobs will fail and need to be retried, and HDFS will be inaccessible until the single NameNode fully recovers on reboot.
    • Standard Cluster — 1 master, N Workers (default for multi-node)
      • Standard configuration with separate master and worker nodes.
    • High Availability Cluster — 3 masters, N Workers (Hadoop HA)
      • HDFS High Availability and YARN High Availability are configured to allow uninterrupted YARN and HDFS operations despite any single-node failures/reboots.
  • All nodes in a High Availability cluster reside in the same zone. If there is a failure that impacts all nodes in a zone, the failure will not be mitigated.

Dataproc Cluster Scaling

  • Dataproc cluster can be adjusted to scale by increasing or decreasing the number of primary or secondary worker nodes (horizontal scaling).
  • Dataproc cluster can be scaled at any time, even when jobs are running on the cluster.
  • Machine type of an existing cluster (vertical scaling) cannot be changed. To vertically scale, create a cluster using a supported machine type, then migrate jobs to the new cluster.
  • Dataproc cluster can help scale:
    • to increase the number of workers to make a job run faster
    • to decrease the number of workers to save money
    • to increase the number of nodes to expand available Hadoop Distributed Filesystem (HDFS) storage

Dataproc Cluster Autoscaling

  • Dataproc Autoscaling provides a mechanism for automating cluster resource management and enables cluster autoscaling.
  • An Autoscaling Policy is a reusable configuration that describes how clusters using the autoscaling policy should scale.
  • It defines scaling boundaries, frequency, and aggressiveness to provide fine-grained control over cluster resources throughout cluster lifetime.
  • Recent enhancements to Dataproc autoscaling have shown to decrease cluster VM expenditures by up to 40% and reduce cumulative job runtime by 10%.
  • Autoscaling is recommended for:
    • clusters that store data in external services, such as Cloud Storage
    • clusters that process many jobs
    • scaling up single-job clusters
  • Autoscaling is not recommended with/for:
    • HDFS: Autoscaling is not intended for scaling on-cluster HDFS.
    • YARN Node Labels: Autoscaling does not support YARN Node Labels. YARN incorrectly reports cluster metrics when node labels are used.
    • Spark Structured Streaming: Autoscaling does not support Spark Structured Streaming.
    • Idle Clusters: Autoscaling is not recommended for the purpose of scaling a cluster down to minimum size when the cluster is idle. Use Scheduled Stop or delete idle clusters instead.
  • Dataproc also supports Autotuning (Premium tier), which uses Gemini AI to automatically tune Spark properties, optimize memory allocation, and prevent OOM errors based on historical job patterns.

Dataproc Zero-Scale Clusters

  • Zero-scale clusters use only secondary workers (Spot VMs) that can be scaled down to zero when no processing is active.
  • Unlike standard clusters that require at least two primary workers, zero-scale clusters leave only the master node online to preserve metadata.
  • Ideal for development and testing environments where you want to eliminate idle compute costs.
  • Workers automatically scale up when jobs are submitted and scale back to zero when idle.

Dataproc Cluster Lifecycle Management

  • Scheduled Deletion — Automatically delete a cluster after a specified idle period, at a specified future time, or after a specified duration from creation.
  • Scheduled Stop — Automatically stop (not delete) a cluster after a specified idle period or at a future time. Preserves cluster configuration for easy restart.
  • Cluster Rotation — Recreate clusters at regular intervals for security patching and freshness.
  • Start/Stop — Manually stop and restart clusters to save costs without losing configuration.

Dataproc Workers

  • Primary workers are standard Compute Engine VMs.
  • Secondary workers can be used to scale compute with the below characteristics:
    • Processing only
      • Secondary workers do not store data.
      • Can only function as processing nodes.
      • Useful to scale compute without scaling storage.
    • No secondary-worker-only clusters (except zero-scale clusters)
      • Standard clusters must have primary workers.
      • Dataproc adds two primary workers by default if none are specified.
    • VM Types for Secondary Workers
      • Spot VMs (recommended) — Latest version of preemptible VMs with no maximum runtime limit. Can be reclaimed at any time.
      • Preemptible VMs (legacy) — Limited to 24-hour runtime. Spot VMs are recommended instead.
      • Non-preemptible VMs — Standard pricing, not subject to reclamation.
    • Persistent disk size
      • Created, by default, with the smaller of 100GB or the primary worker boot disk size.
      • This disk space is used for local caching of data and is not available through HDFS.
    • Asynchronous Creation
      • Dataproc manages secondary workers using Managed Instance Groups (MIGs), which create VMs asynchronously as soon as they can be provisioned.
  • Flexible VMs (GA 2026) — Define up to ten ranked machine types for worker nodes. Dataproc dynamically scans the entire region to fulfill capacity requests, improving resilience against localized shortages.

Dataproc Driver Node Groups

  • Driver node groups provide dedicated nodes for running Spark drivers, separating them from executors running on worker nodes.
  • Recommended for shared clusters running many concurrent jobs to prevent driver resource contention.
  • Increase master node resources before using driver node groups to avoid limitations.

Dataproc Initialization Actions

  • Dataproc supports initialization actions in executables or scripts that will run on all nodes in the cluster immediately after the cluster is set up.
  • Initialization actions often set up job dependencies, such as installing Python packages, so that jobs can be submitted to the cluster without having to install dependencies when the jobs are run.

Dataproc Cloud Storage Connector

  • Dataproc Cloud Storage connector helps Dataproc use Google Cloud Storage as the persistent store instead of HDFS.
  • Cloud Storage connector helps separate the storage from the cluster lifecycle and allows the cluster to be shut down when not processing data.
  • Cloud Storage connector benefits:
    • Direct data access — Store the data in Cloud Storage and access it directly. You do not need to transfer it into HDFS first.
    • HDFS compatibility — Can easily access your data in Cloud Storage using the gs:// prefix instead of hdfs://.
    • Interoperability — Storing data in Cloud Storage enables seamless interoperability between Spark, Hadoop, and Google services.
    • Data accessibility — Data is accessible even after shutting down the cluster, unlike HDFS.
    • High data availability — Data stored in Cloud Storage is highly available and globally replicated without a loss of performance.
    • No storage management overhead — Unlike HDFS, Cloud Storage requires no routine maintenance, such as checking the file system, or upgrading or rolling back to a previous version of the file system.

Dataproc Open Table Format Support

  • Dataproc supports modern open table formats as optional cluster components:
    • Apache Iceberg — Supports creating and querying Iceberg tables with metadata in Dataproc Metastore or BigLake Metastore.
    • Delta Lake — Supports reading and writing Delta tables on Cloud Storage.
    • Apache Hudi — Supports Hudi’s Copy-on-Write and Merge-on-Read table types.
  • Integration with Google Cloud Lakehouse enables read/write interoperability between Managed Service for Apache Spark and BigQuery using a unified metadata layer.

Dataproc on GKE

  • Dataproc on GKE allows running Spark and other data processing workloads on a Google Kubernetes Engine (GKE) cluster.
  • Provides Kubernetes-native resource management, scaling, and multi-tenancy for Spark workloads.
  • Useful for organizations that have standardized on Kubernetes and want unified infrastructure management.
  • Supports custom container images and executor pod scheduling on specific node pools.

Cloud Dataproc vs Dataflow

Refer blog post @ Cloud Dataproc vs Dataflow

GCP Certification Exam Practice Questions

  • Questions are collected from Internet and the answers are marked as per my knowledge and understanding (which might differ with yours).
  • GCP services are updated everyday and both the answers and questions might be outdated soon, so research accordingly.
  • GCP exam questions are not updated to keep up the pace with GCP updates, so even if the underlying feature has changed the question might not be updated
  • Open to further feedback, discussion and correction.
  1. Your company is forecasting a sharp increase in the number and size of Apache Spark and Hadoop jobs being run on your local data center. You want to utilize the cloud to help you scale this upcoming demand with the least amount of operations work and code change. Which product should you use?
    1. Google Cloud Dataflow
    2. Google Cloud Dataproc
    3. Google Compute Engine
    4. Google Kubernetes Engine
  2. Your company is migrating to the Google cloud and looking for HBase alternative. Current solution uses a lot of custom code using the observer coprocessor. You are required to find the best alternative for migration while using managed services, if possible?
    1. Dataflow
    2. HBase on Dataproc
    3. Bigtable
    4. BigQuery
  3. A data engineering team runs hundreds of short-lived Spark ETL jobs daily. They want to minimize infrastructure management and only pay for actual job execution time. Which deployment option is most appropriate?
    1. Dataproc cluster with autoscaling
    2. Dataproc Serverless (Managed Service for Apache Spark — Serverless)
    3. Dataproc on GKE
    4. Dataproc with scheduled deletion
  4. Your organization wants to accelerate existing Spark SQL workloads on Dataproc by up to 4.9x without modifying application code. Which feature should you enable?
    1. Dataproc Autoscaling
    2. Dataproc Enhanced Flexibility Mode
    3. Lightning Engine
    4. Dataproc Premium Machine Types
  5. A team wants a persistent Dataproc development environment that automatically stops incurring worker costs when no jobs are running, while preserving cluster metadata. Which feature should they use?
    1. Scheduled Deletion
    2. Standard Autoscaling
    3. Single Node Cluster
    4. Zero-Scale Cluster
  6. Your Dataproc cluster frequently fails to scale due to temporary capacity constraints in the selected zone. What feature would improve resource obtainability? (Choose TWO)
    1. Flexible VMs with ranked machine type preferences
    2. Auto Zone Placement
    3. Increasing the autoscaling cooldown period
    4. Using only preemptible VMs
  7. Which of the following are NOT recommended use cases for Dataproc Autoscaling? (Choose TWO)
    1. Clusters that store data in Cloud Storage
    2. Clusters running Spark Structured Streaming
    3. Scaling on-cluster HDFS storage
    4. Clusters processing many batch jobs

See also: Google Cloud Data Services Cheat Sheet

References

Google Cloud Data Analytics Services Cheat Sheet

Cloud Pub/Sub

  • Pub/Sub is a fully managed, asynchronous messaging service designed to be highly reliable and scalable with latencies on the order of 100 ms
  • Pub/Sub offers at-least-once message delivery and best-effort ordering to existing subscribers
  • Pub/Sub also supports exactly-once delivery (GA since 2022) for pull subscriptions and StreamingPull API, ensuring messages are not redelivered after successful acknowledgment. Push and export subscriptions do not support exactly-once delivery.
  • Pub/Sub enables the creation of event producers and consumers, called publishers and subscribers.
  • Pub/Sub messages should be no greater than 10MB in size.
  • Messages can be received with pull or push delivery.
  • Messages published before a subscription is created will not be delivered to that subscription
  • Acknowledged messages are no longer available to subscribers and are deleted, by default. However, can be retained setting retention period.
  • Publishers can send messages with an ordering key and message ordering is set, Pub/Sub delivers the messages in order.
  • Pub/Sub support encryption at rest and encryption in transit.
  • Seek feature allows subscribers to alter the acknowledgment state of messages in bulk to replay or purge messages in bulk.
  • Supports BigQuery subscriptions to write messages directly to BigQuery tables without additional processing.
  • Supports Cloud Storage subscriptions to write messages to Cloud Storage buckets in Avro or Text format.
  • Message filtering allows subscribers to receive a subset of messages published to a topic using filter expressions.
  • Pub/Sub Lite is deprecated (EOL March 18, 2026). Migrate to standard Pub/Sub for cost-effective messaging.

BigQuery

  • BigQuery is a fully managed, durable, petabyte scale, serverless, highly scalable, and cost-effective multi-cloud data warehouse that has evolved into an AI data platform.
  • supports a standard SQL dialect. Legacy SQL is deprecated — effective June 1, 2026, BigQuery limits legacy SQL use for organizations that have not used it between Nov 2025–Jun 2026.
  • automatically replicates data and keeps a seven-day history of changes (time travel), allowing easy restoration and comparison of data from different times
  • supports federated data and can process external data sources in GCS for Parquet and ORC open-source file formats, transactional databases (Bigtable, Cloud SQL), or spreadsheets in Drive without moving the data.
  • BigLake provides a unified storage engine for data lakehouse workloads, supporting Apache Iceberg tables with fine-grained governance across multiple engines (Spark, Flink, Trino, BigQuery).
  • Data model consists of Datasets, tables
  • BigQuery performance can be improved using Partitioned tables and Clustered tables.
  • BigQuery encrypts all data at rest and supports encryption in transit.
  • BigQuery Data Transfer Service automates data movement into BigQuery on a scheduled, managed basis
  • BigQuery Editions (Standard, Enterprise, Enterprise Plus) provide different capability tiers with slot-based pricing, autoscaling reservations, and capacity commitments.
  • BigQuery Studio provides a unified workspace with SQL editor, notebooks (Colab Enterprise), and data canvas for end-to-end analytics workflows.
  • BigQuery ML (BQML) allows building and deploying ML models using SQL, including integration with Gemini and Vertex AI for generative AI tasks like text summarization, sentiment analysis, and embeddings.
  • Vector Search enables similarity search using embeddings directly in BigQuery, supporting RAG applications, semantic search, and KNN-based retrieval without needing external vector databases.
  • BI Engine provides in-memory caching and vectorized processing for sub-second query response times, accelerating dashboards and visualization tools.
  • Best Practices
    • Control projection, avoid select *
    • Estimate costs as queries are billed according to the number of bytes read and the cost can be estimated using --dry-run feature
    • Use the maximum bytes billed setting to limit query costs.
    • Use clustering and partitioning to reduce the amount of data scanned.
    • Avoid repeatedly transforming data via SQL queries. Materialize the query results in stages.
    • Use streaming inserts only if the data must be immediately available as streaming data is charged.
    • Prune partitioned queries, use the _PARTITIONTIME pseudo column to filter the partitions.
    • Denormalize data whenever possible using nested and repeated fields.
    • Avoid external data sources, if query performance is a top priority
    • Avoid using Javascript user-defined functions
    • Optimize Join patterns. Start with the largest table.
    • Use the expiration settings to remove unneeded tables and partitions
    • Keep the data in BigQuery to take advantage of the long-term storage cost benefits rather than exporting to other storage options.
    • Use BigQuery editions with autoscaling for predictable costs and optimal performance.

Bigtable

  • Bigtable is a fully managed, scalable, wide-column NoSQL database service with up to 99.999% availability.
  • ideal for applications that need very high throughput and scalability for key/value data, where each value is max. of 10 MB.
  • supports high read and write throughput at low latency and provides consistent sub-10ms latency – handles millions of requests/second
  • is a sparsely populated table that can scale to billions of rows and thousands of columns,
  • supports storage of terabytes or even petabytes of data
  • is not a relational database. It does not support joins or multi-row transactions.
  • Now supports GoogleSQL for querying data, including window functions for advanced analytic operations (GA 2026).
  • handles upgrades and restarts transparently, and it automatically maintains high data durability.
  • scales linearly in direct proportion to the number of nodes in the cluster
  • stores data in tables, which is composed of rows, each of which typically describes a single entity, and columns, which contain individual values for each row.
  • Each table has only one index, the row key. There are no secondary indices. Each row key must be unique.
  • Single-cluster Bigtable instances provide strong consistency.
  • Multi-cluster instances, by default, provide eventual consistency but can be configured to provide read-over-write consistency or strong consistency, depending on the workload and app profile settings
  • Bigtable Editions (Enterprise and Enterprise Plus) provide advanced features for performance, analytic query capabilities, and resource management (GA 2026).
  • Data Boost provides serverless compute for analytical queries without impacting operational workloads, eliminating the need for multiple data copies.
  • In-memory tier delivers hotspot resistance supporting up to 120,000 queries per second on a single row for ultra-low latency use cases.

Cloud Dataflow

  • Cloud Dataflow is a managed, serverless service for unified stream and batch data processing requirements
  • provides Horizontal autoscaling to automatically choose the appropriate number of worker instances required to run the job.
  • is based on Apache Beam, an open-source, unified model for defining both batch and streaming-data parallel-processing pipelines.
  • supports Windowing which enables grouping operations over unbounded collections by dividing the collection into windows of finite collections according to the timestamps of the individual elements.
  • supports drain feature to deploy incompatible updates
  • Runner v2 supports cross-language transforms, allowing use of Java transforms from Python pipelines and vice versa.
  • Dataflow Prime provides advanced features including Job Visualizer, Smart Recommendations, vertical autoscaling, and right-fitting for optimal resource utilization.
  • GPU and TPU support (TPU V5E, V5P, V6E) enables running high-volume, low-latency ML inference workloads directly within Dataflow jobs.
  • Global Compute enables enormous scaling by dynamically scheduling workloads across Google’s global infrastructure, automatically determining optimal locations based on data locality and resource availability.
  • Speculative Execution for batch pipelines mitigates the impact of slow-running tasks (stragglers) by launching redundant executions.
  • Scales to 4,000 workers per job and routinely processes petabytes of data.
  • Dataflow SQL was deprecated (July 31, 2024) and is no longer available in Google Cloud CLI as of January 31, 2025.

Managed Service for Apache Spark (formerly Cloud Dataproc)

  • Note: Cloud Dataproc has been rebranded to Managed Service for Apache Spark (2025), consolidating Dataproc on Compute Engine and Google Cloud Serverless for Apache Spark under a unified brand.
  • Managed Service for Apache Spark is a managed Spark and Hadoop service to take advantage of open-source data tools for batch processing, querying, streaming, and machine learning.
  • helps to create clusters quickly, manage them easily, and save money by turning clusters on and off as needed.
  • helps reduce time and money spent on administration and lets you focus on your jobs and your data.
  • has built-in integration with other GCP services, such as BigQuery, Cloud Storage, Bigtable, Cloud Logging, and Monitoring
  • support preemptible instances (now called Spot VMs) that have lower compute prices to reduce costs further.
  • also supports HBase, Flink, Hive WebHcat, Druid, Jupyter, Presto, Solr, Zeppelin, Ranger, Zookeeper, and much more.
  • supports connectors for BigQuery, Bigtable, Cloud Storage
  • can be configured for High Availability by specifying the number of master instances in the cluster
  • All nodes in a High Availability cluster reside in the same zone. If there is a failure that impacts all nodes in a zone, the failure will not be mitigated.
  • supports cluster scaling by increasing or decreasing the number of primary or secondary worker nodes (horizontal scaling)
  • supports Autoscaling that provides a mechanism for automating cluster resource management and enables cluster autoscaling.
  • supports initialization actions in executables or scripts that will run on all nodes in the cluster immediately after the cluster is set up
  • Serverless Spark allows submitting batch workloads without provisioning or managing clusters, with automatic scaling and resource management.
  • Supports Zero-Scale clusters for cost optimization when clusters are idle (2026).
  • Includes Lightning Engine for boosted Spark performance.

Cloud Dataprep

⚠️ SERVICE END OF SUPPORT

Cloud Dataprep by Trifacta reached End of Support in December 2025. Trifacta was acquired by Alteryx, and the service has transitioned to Alteryx Designer Cloud.

Migration Options:

  • Alteryx Designer Cloud — successor to Dataprep by Trifacta with enhanced AI/ML capabilities
  • Cloud Data Fusion — Google Cloud’s managed data integration service for visual ETL/ELT pipelines
  • Dataform — for SQL-based data transformations in BigQuery
  • BigQuery Data Preparations — built-in data preparation within BigQuery Studio
  • Cloud Dataprep by Trifacta was an intelligent data service for visually exploring, cleaning, and preparing structured and unstructured data for analysis, reporting, and machine learning.
  • was fully managed, serverless, and scaled on-demand with no infrastructure to deploy or manage
  • provided easy data preparation with clicks and no code.
  • automatically identified data anomalies & helped take fast corrective action
  • automatically detected schemas, data types, possible joins, and anomalies such as missing values, outliers, and duplicates
  • used Dataflow or BigQuery under the hood, enabling unstructured or structured datasets processing of any size with the ease of clicks, not code

Cloud Datalab

⚠️ SERVICE DEPRECATED

Cloud Datalab was deprecated on September 2, 2022.

Migration Options:

  • Vertex AI Workbench — managed notebook environment with JupyterLab, providing capabilities beyond Datalab with integrated ML workflows
  • Colab Enterprise — collaborative notebook environment integrated with BigQuery Studio
  • Cloud Datalab was a powerful interactive tool created to explore, analyze, transform and visualize data and build machine learning models using familiar languages, such as Python and SQL, interactively.
  • ran on Google Compute Engine and connected to multiple cloud services easily so you could focus on data science tasks.
  • was built on Jupyter (formerly IPython)
  • enabled analysis of the data on Google BigQuery, Cloud Machine Learning Engine, Google Compute Engine, and Google Cloud Storage using Python, SQL, and JavaScript (for BigQuery user-defined functions).

Dataplex / Knowledge Catalog

  • Dataplex (now Knowledge Catalog) is an AI-powered, unified data governance solution for managing, understanding, and governing data and AI assets across Google Cloud.
  • Provides centralized inventory to discover, manage, and govern data across BigQuery, Cloud Storage, Pub/Sub, and Spanner.
  • Supports data products — curated, ready-to-use packages of data assets, documentation, and governance controls assembled to solve specific business problems.
  • Offers automated data discovery, metadata management, data quality checks, data lineage, and semantic search.
  • Integrates with BigQuery Studio for unified governance across analytical workflows.

Related Posts