|
Parameter |
Type |
Description |
Example |
|---|---|---|---|
|
object |
The detailed configuration of a scheduled query. |
||
| script |
string |
The analytic statement of the scheduled query. |
* | select * |
| sqlType |
string |
The SQL type. |
searchQuery |
| destEndpoint |
string |
The destination endpoint. |
cn-hangzhou-intranet.log.aliyuncs.com |
| destProject |
string |
The destination project. |
project-demo |
| sourceLogstore |
string |
The source logstore. |
source-logstore-demo |
| destLogstore |
string |
The destination logstore. |
dest-logstore-demo |
| roleArn |
string |
The Alibaba Cloud Resource Name (ARN) of the role used to execute the SQL statement. |
acs:ram::123456789:role/aliyunlogetlrole |
| destRoleArn |
string |
The ARN of the role used to write data to the destination. |
acs:ram::123456789:role/aliyunlogetlrole |
| fromTimeExpr |
string |
The start of the SQL time window. |
@m-1m |
| toTimeExpr |
string |
The end of the SQL time window. |
@m |
| maxRunTimeInSeconds |
integer |
The maximum timeout period for SQL execution. Unit: seconds. Valid values: 60 to 1800. |
600 |
| resourcePool |
string |
The resource pool type. A value of enhanced indicates the enhanced resource pool. |
enhanced |
| maxRetries |
integer |
The maximum number of retries upon SQL timeout. Valid values: 1 to 100. |
20 |
| fromTime |
integer |
The start time. For more information, see From Logstore to MetricStore. |
1712592000 |
| toTime |
integer |
The end time. For more information, see From Logstore to MetricStore. |
0 |
| dataFormat |
string |
The write mode. Three configurations are supported: log2log, log2metric, and metric2metric. |
log2log |
| maxConcurrency |
integer |
The concurrency. |
1 |
| forceComplete |
boolean |
Specifies whether to ensure accurate computation results. |
true |
| usingExactlyOnce |
boolean |
Specifies whether to use the Exactly-Once write protocol. |
|
| parameters |
object |
The SQL configuration. For more information, see From Logstore to MetricStore. |
{ addLabels: "{}", hashLabels: "[]", labelKeys: "[\"your label1\",\"your label2\"]", metricKeys: "[\"your Indicator1\",\"your Indicator2\"]", metricName: "", timeKey: "" } |