YoVDO

Datastream MySQL to BigQuery

Offered By: Google Cloud via Coursera

Tags

BigQuery Courses Data Warehousing Courses MySQL Courses

Course Description

Overview

This is a self-paced lab that takes place in the Google Cloud console. Learn to migrate MySQL Databases to BigQuery using Datastream and Dataflow.

Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. In this lab you'll learn how to replicate data from your OLTP workloads into BigQuery, in real time.

You will begin by deploying MySQL on Cloud SQL and import a dataset using the gcloud command line. Then, in the Cloud Console UI, you will create and start a Datastream stream and a Dataflow job for replication. The replication uses a Dataflow template to enable continuous replication of data, along with Cloud Storage and Pub/Sub for buffering data.

Taught by

Google Cloud Training

Related Courses

Serverless Data Analysis with Google BigQuery and Cloud Dataflow en Français
Google Cloud via Coursera
Google Cloud Big Data and Machine Learning Fundamentals en Español
Google Cloud via Coursera
Google Cloud Big Data and Machine Learning Fundamentals 日本語版
Google Cloud via Coursera
Industrial IoT on Google Cloud
Google Cloud via Coursera
Google Cloud Platform Big Data and Machine Learning Fundamentals em Português Brasileiro
Google Cloud via Coursera