Tencent Cloud

Recent Pages

Query Script Analysis

Last updated: 2024-08-07 17:08:48

To facilitate users in quickly handling repetitive query tasks, DLC provides script file analysis.
Note
 The console allows saving up to 100 SQL scripts.
Creating a New Query Directory
1. Log in to DLC Console > Script Query Page.
2. On the query page, click Add Query Directory.
﻿
3. After filling in the directory configuration, you can save and complete the creation.
﻿
﻿
Directory name: Supports Chinese characters, letters, and underscores (_), up to 25 characters.
Permission settings: You can set the visibility permissions for the script directory and the scripts within it based on the perspective of the workgroup or user.
Creating a New Query Script
1. Log in to DLC Console > Script Query Page, You can click the library 
﻿
 icon or directly add execution and save.
2. After the computation engine is selected, click Run to execute the script.
﻿
Saving a Query Script
1. After the query is completed, click the Save button.
2. Queries created through the library will be saved under the directory of that library. Queries added through the tab bar can be saved directly in the root directory or an authorized library.
﻿
﻿
﻿
3. Query table permissions can be customized according to the public scope of the library, and table usage permissions can be specified for the public scope.
﻿
Viewing script information
1. Hover the mouse pointer over the script name to view the script details.
﻿
﻿
﻿
2. Click the 
﻿
 icon next to the table you want to view, and select to open or query it.
﻿
﻿
﻿
Deleting a Query Script
Click the 
﻿
 icon next to the table  you want to delete, and select to delete the script.
﻿
﻿
﻿
Note:
Deleted scripts cannot be restored. Operate with caution.
﻿