SHOW ETLS lists all extract, transform, and load (ETL) tasks in the current resource group, or filters tasks by name using a wildcard pattern.
Engine and version
SHOW ETLS applies only to the stream engine. Version 3.1.8 or later is required.
View the current version and update the minor version in the console.
Syntax
show_etls_statement ::= SHOW ETLS [ LIKE string_literal ]Usage notes
LIKE clause
The LIKE clause accepts a string literal that the system uses to perform a wildcard match on system properties. The string literal supports two wildcard characters:
%: Matches zero or more characters._: Matches exactly one character.
Output fields
| Field | Description |
|---|---|
| ETL_ID | The name of the ETL task. |
| ETL_VERSION | The version number of the ETL task. Only the latest version is shown. |
| STATUS | The status of the ETL task. See Task status. |
| JOB_RESTART_NUM | The number of times the ETL task has been restarted. |
| NUM_RECORDS | The number of data records processed by the ETL task. |
| RECORDS_PER_SEC | The number of records processed per second. |
| NUM_BYTES | The total amount of data processed, in bytes. |
| BYTES_PER_SEC | The amount of data processed per second, in bytes. |
| EVENT_TIME_LAG | The data processing latency, in milliseconds (ms). |
A negativeEVENT_TIME_LAGvalue (for example,-1.0) indicates no data is currently flowing into the ETL task.
Task status
| Status | Description |
|---|---|
| SUBMIT | The task is submitted. |
| RUNNING | The task is currently running. |
| DELETE | The task is being deleted. |
Examples
List all ETL tasks
SHOW ETLS;Output:
+---------+---------------+---------+-----------------+-------------+-----------------+-----------+---------------+----------------+
| ETL_ID | ETL_VERSION | STATUS | JOB_RESTART_NUM | NUM_RECORDS | RECORDS_PER_SEC | NUM_BYTES | BYTES_PER_SEC | EVENT_TIME_LAG |
+---------+---------------+---------+-----------------+-------------+-----------------+-----------+---------------+----------------+
| filter1 | 1753940184757 | RUNNING | 0 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 |
| filter2 | 1753945414775 | RUNNING | 0 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 |
+---------+---------------+---------+-----------------+-------------+-----------------+-----------+---------------+----------------+Filter tasks by name pattern
List all ETL tasks whose names start with filter:
SHOW ETLS LIKE 'filter%';Output:
+---------+---------------+---------+-----------------+-------------+-----------------+-----------+---------------+----------------+
| ETL_ID | ETL_VERSION | STATUS | JOB_RESTART_NUM | NUM_RECORDS | RECORDS_PER_SEC | NUM_BYTES | BYTES_PER_SEC | EVENT_TIME_LAG |
+---------+---------------+---------+-----------------+-------------+-----------------+-----------+---------------+----------------+
| filter1 | 1753940184757 | RUNNING | 0 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 |
| filter2 | 1753945414775 | RUNNING | 0 | 0.0 | 0.0 | 0.0 | 0.0 | -1.0 |
+---------+---------------+---------+-----------------+-------------+-----------------+-----------+---------------+----------------+