Google BigQuery Connectors > Part I: Introduction to Google BigQuery connectors > Connector use cases > 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.