Returns the details of a specified ETL task, including its schema, data insertion logic, current status, and resource group assignment.
Engine and version
DESCRIBE ETL is only available for the stream engine and requires version 3.1.8 or later.
Note
To check your current version or upgrade, see Upgrade the minor engine version of an ApsaraDB for Lindorm instance.
Syntax
{ DESCRIBE | DESC } ETL etl_nameBoth DESCRIBE and DESC are valid.
Parameters
| Parameter | Required | Description |
|---|---|---|
etl_name | Yes | The name of the ETL task to query. |
Result set
| Field | Description |
|---|---|
| ETL_ID | The name of the ETL task. |
| ETL_VERSION | The version of the ETL task. |
| SOURCE_SCHEMA | The fields of the source table. |
| SINK_SCHEMA | The fields of the sink table. |
| CONTENT | The complete data insertion logic of the ETL task. To modify it, use the ALTER ETL statement. |
| ATTRIBUTES | The ETL properties (etl_properties) set when the task was created. Empty if no properties were set. |
| STATUS | The status of the ETL task. Valid values: SUBMIT (submitted), RUNNING (running), DELETE (being deleted). |
| RESOURCE_GROUP | The resource group the task is using. To change it, use the SET statement. |
| CREATE_USER | The user who created the ETL task. |
| CREATE_TIME | The time when the ETL task was created. |
Example
Query the details of the ETL task filter1 in the current resource group.
DESC ETL filter1;Result:
+---------+---------------+------------------------------------------+----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------+------------+---------+------------------+-------------+------------------------------+
| ETL_ID | ETL_VERSION | SOURCE_SCHEMA | SINK_SCHEMA | CONTENT | ATTRIBUTES | STATUS | RESOURCE_GROUP | CREATE_USER | CREATE_TIME |
+---------+---------------+------------------------------------------+----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------+------------+---------+------------------+-------------+------------------------------+
| filter1 | 1747293558894 | `lindorm_table`.`default`.`source`:p1,c1 | `lindorm_table`.`default`.`sink`:p1,c1 | INSERT INTO `lindorm_table`.`default`.`sink` (`p1`, `c1`) SELECT `p1`, `c1` FROM `lindorm_table`.`default`.`source` WHERE `c1` > 10 | {} | RUNNING | lstream-e00s**** | r*** | Thu May 15 15:19:18 CST 2025 |
+---------+---------------+------------------------------------------+----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------+------------+---------+------------------+-------------+------------------------------+