Updated on 2023-12-11 GMT+08:00

Scenario

In this practice, you will learn how to use Cloud Data Migration (CDM), DataArts Factory of DataArts Studio, and GaussDB(DWS) to analyze movie scores and find out the 10 best and most frequently scored movies. You will learn the data migration function of DataArts Migration, and the script development, job development, and job scheduling functions of DataArts Factory, as well as basic SQL syntax of GaussDB(DWS).

This practice involves the DataArts Migration, Management Center, and DataArts Factory modules of DataArts Studio. All DataArts Studio versions can meet requirements.

The procedure is as follows:

  1. Make preparations, including Preparations, preparing data sources, preparing a data lake, and preparing authentication data.
  2. Create a job to migrate data from OBS to DWS. For details, see Migrating Data from OBS to DWS.
  3. Develop data, including creating DWS SQL scripts and a job.
  4. Unsubscribe from services. If you do not want to use DataArts Studio and related services, unsubscribe from them and delete resources in a timely manner.