Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Google BigQuery connectors
  3. Part 2: Data Integration with Google BigQuery V2 Connector
  4. Part 3: Data Integration with Google BigQuery Connector

Google BigQuery Connectors

Google BigQuery Connectors

Mapping and mapping task use case

Mapping and mapping task use case

You work for an organization that stores purchase order details, such as customer ID, item codes, and item quantity in an on-premise MySQL database. You need to analyze purchase order details to know the items ordered in a particular state and move data from the on-premise MySQL database to state-wise target tables in an affordable cloud-based environment.
Use Google BigQuery V2 Connector to create a mapping to state-wise read purchase records from the MySQL database and write them to multiple Google BigQuery targets to prepare an upcoming marketing campaign for all states.

0 COMMENTS

We’d like to hear from you!