DataWorks:Data Studio (legacy version) tutorial

Case study introduction

Extract basic user profile data—such as geographical and social attributes—from website behavior to support business strategy decisions. Scheduled profile analysis enables fine-grained traffic operations. DataWorks and EMR Serverless StarRocks handle data synchronization, transformation, management, and consumption.

Data Studio

This tutorial uses the DataWorks Data Studio (legacy version) platform. Ensure that your workspace is not set to Use Data Studio (New Version).

• When you create a workspace, do not select the Use Data Studio (New Version) option.

• After February 18, 2025, the Data Studio (new version) is enabled by default when you use an Alibaba Cloud account to enable DataWorks and create a workspace for the first time in the following regions. If the Data Studio (new version) is already enabled by default for your account, see Use Data Studio (new version).

  China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Ulanqab), China (Shenzhen), China (Chengdu), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), Indonesia (Jakarta), Thailand (Bangkok), Germany (Frankfurt), UK (London), US (Silicon Valley), US (Virginia)

Procedure

1. Prepare the environment

   Create the StarRocks instance and DataWorks workspace required for this tutorial, and complete the related resource group network configuration.

2. Data synchronization

   Configure a data synchronization channel in DataWorks to synchronize the user information and website log data provided in this tutorial to the StarRocks computing resource. Then, you can query the synchronized data.

3. Transform data

   Use the StarRocks node in DataWorks to transform the data in the user information table and the access log table that were synchronized to StarRocks. This process generates the target user profile data.

4. Monitor data quality

   Configure data quality monitoring rules for the tables generated from data transformation. This helps you detect and block dirty data in advance and prevent its impact from spreading.

5. Manage data

   After the user profile analysis task workflow is complete, the corresponding data tables are created in StarRocks. You can view the generated data tables and their lineage in the Data Map module.

6. Consume data

   • After the user profile analysis is complete, use the Data Analysis module to visualize the transformed data. This helps you quickly extract key information and gain insights into business trends.

   • After you obtain the final transformed data, use the DataService Studio module to share and apply the data through a standard API-based data service. This provides data to other business modules that use APIs.