View and manage execution records - Dataphin - Alibaba Cloud Documentation Center

Execution records store data query records from the last 15 days for various object types, such as ad hoc queries, compute node runs, logical data table previews, smoke testing for derived metrics, and OpenAPI. This topic describes how to view these execution records.

View execution records

On the top menu bar of the Dataphin home page, select Development > Data Development.
On the top menu bar of the Development page, select a project. In Dev-Prod mode, select an environment.
In the navigation pane on the left, click Execution History. In the Execution History list, select an execution record from a specific date.
On the execution record page, you can view the operational log, execution results, and basic details. The basic details include Object Name, Object Type, Code Type, Duration, Start Time, Executor, and Related Table. You can also perform operations on the record, such as View Code, Stop, Delete, and Download Result.
- View Code: View the script.
- Stop: Super administrators, system administrators, project administrators, and the node executor can stop the node or object.
- Delete: You cannot delete a record while it is running. This action cannot be undone.
- Download Result: Download the results of a successful execution. You can download the full data or sample data.
  - Full data download: The full data is downloaded in CSV format. This download may take a long time. You can monitor the download progress in the Message Center or in the execution record.
    Important
    For ad hoc database SQL queries, you cannot download the full query results. Only sample data downloads are supported.
    A full data download operation creates a temporary table based on the query statement. For SPARK_SQL ad hoc queries on a Hadoop compute engine, the temporary table is created using the default storage format specified in Management Center > System Settings > Development Platform > Table Management Settings.
    For example, if the default storage format in Table Management Settings is hudi, the using hudi statement is added when the temporary table is created. If the default storage format is Engine default, no storage format is specified when the temporary table is created.
  - Sample data download: The format of the downloaded sample data and the data in the execution records are determined by the data download approval settings. For more information, see Data download configuration.
    Note
    If the download approval feature is enabled in the specification settings, you must submit a data download request before you can download the data. After the request is approved, you can view the approval node and current execution results, or download the data from the execution record. For more information, see Data download approval configuration.
    When the data download approval watermark feature is enabled, a watermark is automatically added to downloaded Excel files. These files are retained for 30 days. For example, if the data query date is 2023-04-12 and the request date is 2023-04-13, the file expiration date is 2023-04-11. For more information, see Data Download Approval Configuration or .

Manage the execution record list

In the navigation pane on the left, click Execution History. At the bottom of the Execution History list, click Execution Record List to open the Execution Record List page.

On the Execution Record List page, you can view information about execution records and perform operations such as search, view code, view log, stop, and delete.

Ordinal Number	Description
① Search and filter	Quickly filter node execution records by Run by me or Run today. To perform a more precise search, click the icon and filter by criteria such as Status, Executor, File Format, Code Type, Start Time, Duration, Code Search, and Related Table. You can also perform a quick search by script name keyword.
② Execution record list	The list shows the script name/object type, code type, status/duration, start time, executor, and related table. You can also View Code, View Log, Stop, or Delete an execution record. View Code: View the code script. View Log: Click View Log to view the operational log and execution results. Stop: Super administrators, system administrators, project administrators, and the node executor can stop the node or object. Delete: You cannot delete a record while it is running. This action cannot be undone.
③ Batch operations	Perform batch Delete and Stop operations on execution records.