Data Lake Compute provides a script file management feature to facilitate and accelerate repeated query tasks.
Note:
Up to 100 SQL scripts can be saved in the console.
Creating a script
- Log in to the Data Lake Compute console, go to the Query analysis page, and click Resource package.
- On the Resource package tab, hover over the Script file row and click > Create script.
- Enter and save the script content.
- Script name: It can contain up to 25 letters and underscores.
- Script description: It can contain up to 2,048 characters.
- SQL statement: It must be a standard SQL statement containing up to 1,000 characters within 2 MB in size.
Running a script
- Log in to the Data Lake Compute console, go to the Query analysis page, and click Resource package.
- On the Resource package tab, hover over the target script name and click > Copy script to SQL.
- Select the compute engine and click Run.
- Log in to the Data Lake Compute console, go to the Query analysis page, and click Resource package.
- On the Resource package tab, hover over the target script name and click > Learn more to view the script details.
Deleting a script
- Log in to the Data Lake Compute console, go to the Query analysis page, and click Resource package.
- On the Resource package tab, hover over the target script name and click > Delete to delete the script.
Note:
Note that a deleted script cannot be recovered. Proceed with caution.
Was this page helpful?