GOOGLE CLOUD

Data Integration with Cloud Data Fusion

This 2-day course introduces learners to Google Cloud’s data integration capability using Cloud Data Fusion. In this course, we discuss challenges with data integration and the need for a data integration platform (middleware). We then discuss how Cloud Data Fusion can help to effectively integrate data from a variety of sources and formats and generate insights. We take a look at Cloud Data Fusion’s main components and how they work, how to process batch data and real time streaming data with visual pipeline design, rich tracking of metadata and data lineage, and how to deploy data pipelines on various execution engines.

What you will learn

  • Identify the need of data integration

  • Understand the capabilities Cloud Data Fusion provides as a data integration platform

  • Identify use cases for possible implementation with Cloud Data Fusion

  • List the core components of Cloud Data Fusion

  • Design and execute batch and real time data processing pipelines

  • Work with Wrangler to build data transformations

  • Use connectors to integrate data from various sources and formats

  • Configure execution environment; Monitor and Troubleshoot pipeline execution

  • Understand the relationship between metadata and data lineage

Who this course is for

  • Data Engineer

  • Data Analysts

Level

  • Intermediate

Duration

  • 2 x 8 hour session

Prerequisites

  • Completed “Big Data and Machine Learning Fundamentals”

Language

  • Delivered in English

Course TOPICS

Module 1: Introduction to data integration and Cloud Data Fusion

  • Data integration: what, why, challenges

  • Data integration tools used in industry

  • User personas

  • Introduction to Cloud Data Fusion

  • Data integration critical capabilities

  • Cloud Data Fusion UI components

Module 2: Building pipelines

  • Cloud Data Fusion architecture

  • Core concepts

  • Data pipelines and directed acyclic graphs (DAG)

  • Pipeline Lifecycle

  • Designing pipelines in Pipeline Studio

Module 3: Designing complex pipelines

  • Branching, Merging and Joining

  • Actions and Notifications

  • Error handling and Macros

  • Pipeline Configurations, Scheduling, Import and Export

Module 4: Pipeline execution environment

  • Schedules and triggers

  • Execution environment: Compute profile and provisioners

  • Monitoring pipelines

Module 5: Building Transformations and Preparing Data with Wrangler

  • Wrangler

  • Directives

  • User-defined directives

Module 6: Connectors and streaming pipelines

  • Understand the data integration architecture.

  • List various connectors.

  • Use the Cloud Data Loss Prevention (DLP) API.

  • Understand the reference architecture of streaming pipelines.

  • Build and execute a streaming pipeline

Module 7: Metadata and data lineage

  • Metadata

  • Data lineage

Module 8: Summary

  • Course Summary

Ref: T-DICDF-I-01

Have questions?

No worries. Send us a quick message and we'll be happy to answer any questions you have.

© Copyright 2023. Axalon. All rights reserved.

Facebook site
LinkedIn profile