This topic describes how to configure settings on the System Management page of DataAnalysis. You can manage the sharing and download permissions on SQL query records, workbooks, and MaxCompute tables on the System Management page in DataAnalysis. You can also specify upper limits for the number of SQL query records that can be viewed and the number of SQL query records that can be downloaded.

Limits

  • You can go to the System Management page only by using your Alibaba Cloud account or a RAM user that is assigned the tenant administrator role.
  • The settings that you configure on the System Management page take effect only for the current tenant in the current region.
  • On the System Management page, you can configure the Upper Limit for Records Allowed to View and Upper Limit for Records Allowed to Download parameters.
    • In DataWorks Basic Edition, the maximum values of the Upper Limit for Records Allowed to View and Upper Limit for Records Allowed to Download parameters are 10000.
    • In DataWorks of an advanced edition, the default value and maximum value of the Upper Limit for Records Allowed to View parameter are both 10000. The default value of the Upper Limit for Records Allowed to Download parameter is 10000, and the maximum value of this parameter is 200000.

Go to the System Management page

  1. Log on to the DataWorks console and go to the DataAnalysis page. For more information, see Go to the DataAnalysis page.
  2. In the top navigation bar of the DataAnalysis page, choose More > System Management to go to the System Management page.

Manage SQL query records

On the System Configurations page, you can specify upper limits for the number of SQL query records that can be viewed and the number of SQL query records that can be downloaded. You can also specify the resource groups you want to use to run SQL nodes. System Management
  • Upper Limit for Records Allowed to View: the upper limit for the number of SQL query records that can be viewed. Maximum value: 10000.
  • Allow Download and Upper Limit for Records Allowed to Download:

    After you turn on Allow Download in the SQL Query section of the System Management page, users can download the query result. The Upper Limit for Records Allowed to Download parameter specifies the upper limit for the number of SQL query records that can be downloaded. The maximum value of this parameter is 200000.

  • Resource Group: You can specify the resource group that you want to use to run SQL nodes in DataAnalysis.
    You can select a resource group for scheduling from the drop-down list to the right of a compute engine. The drop-down list displays only resource groups for scheduling that have passed the network connectivity test. This ensures the high efficiency of SQL nodes. If you do not configure the Resource Group parameter, the resource group that first passes the network connectivity test is used to run SQL nodes.
    Note You can test the network connectivity between a data source and a resource group when you add the data source. Then, you can view the network connectivity test results on the Data Source page. For more information about how to add a data source and test the network connectivity between the data source and a resource group, see Add a data source.

Manage workbooks

After you turn on Allow Sharing and Allow Download in the Spreadsheet section of the System Management page, users can use the sharing and download features on the Spreadsheet tab. For more information, see Export, share, and download a workbook.

Manage MaxCompute tables

After you turn on Allow Sharing in the Dimension Table section of the System Management page, users can use the sharing feature on the Dimension Table tab to manage the permissions on MaxCompute tables. For more information, see Share a MaxCompute table.