All Products
Search
Document Center

DataWorks:Download data

Last Updated:Nov 13, 2024

Data in CSV and XLSX files downloaded from DataStudio, DataAnalysis, or Security Center is synchronized and saved to the Download Data page. The data download feature allows you to re-download files that have been previously downloaded to your on-premises machine. You can also trace the operation details of historical downloads.

Prerequisites

You have downloaded data in the following modules:

  • DataAnalysis > SQL Query: You can execute SQL statements to query data and download query results on the SQL Query page in DataAnalysis. For more information, see SQL query.

  • DataAnalysis > Spreadsheet: You can download data on the Spreadsheet page in DataAnalysis. For more information, see Export, share, and download a workbook.

  • DataStudio > query and download: You can execute SQL statements to query data and download query results by using the related feature in DataStudio. For more information, see Overview.

  • Security Center > Entity transfer: You can download data on the Entity transfer page in Security Center. For more information, see Transfer entities.

Limits

  • You can download data only in the following modules: DataAnalysis > SQL Query, DataAnalysis > Spreadsheet, DataStudio > query and download, and Security Center > Entity transfer.

  • Only files in the downloadable state can be downloaded.

Go to the Download Data page

  1. Go to the DataStudio page.

    Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and Governance > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

  2. In the upper-left corner of the DataStudio page, click the image.png icon and choose All Products > Data Integration > Upload and Download.

  3. In the left-side navigation pane of the Upload and Download page, click the image.png icon. The Download Data page appears.

Download data

On the Download Data page, you can specify filter conditions, such as file name, module to which the file belongs, file generation date, and file status to search for the data that you want to download. Then, you can view and download the data.

Note
  • You can download data only in the following modules: DataAnalysis > SQL Query, DataAnalysis > Spreadsheet, DataStudio > query and download, and Security Center > Entity transfer.

  • Only files in the downloadable state can be downloaded.

imageFile status description:

  • Downloadable: The file can be downloaded.

  • Download Rejected: An extension that is used to handle the pre-event for data download is configured by an Alibaba Cloud account or a RAM user that has high permissions to block the download operation.

  • Expired: Files are retained for seven days on the Download Data page after they are downloaded from a module. The files expire after seven days and can no longer be downloaded.

  • Risk detection in: Risk detection is enabled for the file that you want to download. If the detection is not complete or fails, the file cannot be downloaded. By default, risk detection is disabled. If an extension that is used to handle the pre-event for data download is configured by an Alibaba Cloud account or a RAM user that has high permissions, DataWorks will detect risks. You can handle risks based on the check results.

References

  • For information about extensions, see Overview.

  • For information about DataStudio, see Overview.

  • For information about DataAnalysis, see Overview.

  • For information about Security Center, see Overview.