A retail analytics team needs to build a new data pipeline to ingest, clean, and transform transactional records from multiple database sources before loading them into their analytics storage. The team has established the following requirements: The pipeline must provide a drag-and-drop, visual user interface to design transformations. Business analysts must be able to build and deploy ETL workflows without writing Java or Python code. The service must offer pre-built connectors and interactive data wrangling tools. Which Google Cloud service should the team select?

Cloud Data Fusion: ### **What Cloud Data Fusion is** **Cloud Data Fusion** is Google Cloud's fully managed, cloud-native data integration service that provides a graphical user interface for building and managing scalable **ETL/ELT** data pipelines. Built on the open-source CDAP (Cask Data Application Platform) framework, it allows organizations to ingest data from heterogeneous sources, apply complex transformations visually, and sink transformed datasets into analytics destinations such as BigQuery without writing underlying code. ### **How it meets the requirements** - **Visual pipeline designer (✓):** Cloud Data Fusion features **Pipeline Studio**, a web-based, drag-and-drop graphical canvas where users can visually map source systems, transformation plugins, and data sinks. - **Code-free workflow development (✓):** Business analysts and non-developers can design end-to-end extraction, transformation, and loading logic without needing software development skills in Java, Scala, or Python. - **Interactive data wrangling (✓):** The built-in **Wrangler plugin** offers a spreadsheet-like data preparation interface to profile data, clean text fields, convert data types, filter unwanted records, and apply conditional logic interactively. - **Pre-built connectors (✓):** Provides over 150 turnkey connectors and plugins for various relational databases, cloud storage services, enterprise applications, and file formats. ### **Key advantages and capabilities** - **Managed execution runtime:** Pipelines designed visually are automatically translated into distributed Apache Spark/MapReduce jobs that run on ephemeral Cloud Dataproc clusters managed seamlessly behind the scenes. - **Data lineage and metadata tracking:** Automatically captures end-to-end dataset metadata and transformation lineage, integrating directly with Dataplex and Data Catalog for enterprise governance. - **Built-in scheduling and alerts:** Allows users to schedule periodic batch runs, configure retry behaviors, and set up notification alerts without requiring third-party orchestration tools. - **Extensibility:** Enables developers to insert custom Python/JavaScript transforms or reusable custom plugins when specialized processing logic is required. ### **Why this is optimal** Cloud Data Fusion is the optimal choice because it specifically targets users who need a **no-code visual ETL interface**. In contrast to programmatic frameworks like Dataflow or code-driven cluster solutions like Dataproc, Cloud Data Fusion accelerates time-to-value for business analysts while retaining robust distributed data processing capabilities.