When you use a RAM user to create a data transformation job, you can specify a default role to transfer log data within the same account.
Prerequisites
- A project is created. A source Logstore and a destination Logstore are created in the project. The names of the source and destination Logstores and the name of the project are obtained. For more information, see Manage a Logstore and Manage a project.
- A RAM user is created, and the RAM user is granted the required permissions to perform data transformation operations. For more information, see Grant a RAM user the permissions to manage a data transformation job.
Background information
The AliyunLogETLRole system role is granted the permissions to read data from a source Logstore and write transformed data to one or more destination Logstores. You can use only an Alibaba Cloud account to create and delete the system role.
Step 1: Use an Alibaba Cloud account to create the AliyunLogETLRole system role
If you want to use a RAM user that assumes the default role to create a data transformation job, make sure that the AliyunLogETLRole role exists within your Alibaba Cloud account. If the AliyunLogETLRole role does not exist in your Alibaba Cloud account, you need to contact the owner of your Alibaba Cloud account to create the role.
- Log on to the Log Service console by using your Alibaba Cloud account.
- Grant permissions to the AliyunLogETLRole system role.
- Method 1
Click You must authorize the system role AliyunLogETLRole. Then, follow the wizard to complete the authorization.
- Method 2
In the Create Data Transformation Rule panel, click You must authorize the system role AliyunLogETLRole below Default Role. Then, follow the wizard to complete the authorization.
- Method 1
Step 2: Use the RAM user to create a data transformation job
- Log on to the Log Service console by using the RAM user.
- Go to the data transformation page.
In the Projects section, click the project that you want to manage.
On the tab, click the Logstore that you want to manage.
- On the query and analysis page, click Data Transformation.
- In the upper-right corner of the page, specify a time range for the log data that you want to transform. Make sure that log data exists on the Raw Logs tab.
- In the code editor, enter a data transformation statement. For more information, see Data transformation syntax.
- Preview transformation results.
- Click Quick. You can select Quick or Advanced. For more information, see Preview mode overview.
- Click Preview Data.
View the preview results.
- If data fails to be transformed because the specified statement is invalid or the permissions that are granted are invalid, follow the on-screen instructions to troubleshoot the failure.
- If the transformed data is returned as expected, go to the next step.
- Click Quick.
- Create a data transformation job.
- Click Save as Transformation Rule.
- In the Create Data Transformation Rule panel, configure the parameters and click OK. For more information about the parameters, see Get started with data transformation. The following table describes the key parameters.

Key parameter Description Authorization Method Select Default Role. Authorization Method in Storage Target Select Default Role.
After the data transformation job is created and run, data can be transferred within the same account. For more information, see Manage a data transformation job.