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 the 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 access 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.
  • In DataWorks Basic Edition, a maximum of 10,000 SQL query records can be downloaded. In DataWorks of an advanced edition, 10,000 SQL query records can be downloaded by default, and a maximum of 200,000 SQL query records can be downloaded. The actual maximum number of SQL query records that can be downloaded is determined by the value that you specify for the Upper Limit for Records Allowed to Download parameter in the SQL Query section.

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

After you turn on the Allow Download switch in the SQL Query section of the System Management page, users can download the queried data. You can also specify the upper limits for the number of SQL query records that can be viewed and the number of SQL query records that can be downloaded in this section. After you configure the settings, users can go to the SQL Query tab to view or download data.
  • The upper limit for the number of SQL query records that can be downloaded cannot exceed 200,000.
  • The upper limit for the number of SQL query records that can be viewed cannot exceed 10,000.
System management

Mange workbooks

After you turn on the Allow Sharing and Allow Download switches 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 the Allow Sharing switch 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.