You can use the default role AliyunLogETLRole or a custom role to create a scheduled SQL job. This topic describes how to create and use the default role AliyunLogETLRole.
Background information
The default role AliyunLogETLRole is pre-authorized to perform SQL analysis operations on source logstores or metricstores and to write the results to the destination logstores or metricstores. You only need to create the role, and no additional authorization is required.
Create the default role AliyunLogETLRole
You can create the AliyunLogETLRole using the following methods:
The authorization process must be completed using an Alibaba Cloud account or by a RAM user who has administrative rights.
If the AliyunLogETLRole default role already exists within your Alibaba Cloud account, there is no need to create it again.
Method 1: Click Cloud Resource Access Authorization and follow the on-screen instructions to complete the creation.
Method 2: In the Create Scheduled SQL panel, click Authorize under Default Role and follow the on-screen instructions to complete the creation.
What to do next
When creating a scheduled SQL job, set Write Authorization and SQL Execution Authorization to Default Role. For more information, see Create a scheduled SQL job.