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.
   • Creating DWS SQL Script top_rating_movie for Storing 10 Top-rated Movies
   • Creating DWS SQL Script top_active_movie for Storing 10 Most Frequently Scored Movies
   • Developing and Scheduling a Job. After orchestrating the job and configuring scheduling policies to periodically execute the job, you can obtain the latest top 10 movies every day.
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.