Help Center/ DataArts Studio/ User Guide/ DataArts Security/ Sensitive Data Identification/ Importing Sensitive Data
Updated on 2026-02-13 GMT+08:00
View PDF
Share

Importing Sensitive Data

You can use an Excel template to import sensitive data discovery results in batches. This simplifies sensitive data management and improves the flexibility and efficiency of data masking.

Prerequisites

  • You have the permission to import data on the Sensitive Data Distribution page. You can view and configure the permission on the Roles page of the DataArts Studio instance.
  • You have created DLI, DWS and MRS Hive data connections in Management Center. For details, see Creating a DataArts Studio Data Connection.
  • You have downloaded the import template and fill in it as required. Each row contains a data record.

Constraints

  • Only an .xlsx file no larger than 1 MB can be imported.
  • You can run only one import task at a time.
  • DLI, DWS and MRS Hive connections are supported. (Connections in string mode are not supported.)
  • There are eight columns in the import template. They are RULE NAME, SECRECY LEVELS, DATA CLASSIFICATION, DATABASE, SCHEMA, TABLE, COLUMN, and IS VALID(Y/N). Do not change or delete them.

  • Among these columns, RULE NAME, SECRECY LEVELS, DATABASE, TABLE, COLUMN, and IS VALID(Y/N) are mandatory. If any of them is missing, data import will fail.

Importing Sensitive Data

  1. On the DataArts Studio console, locate a workspace and click DataArts Security.
  2. In the navigation pane on the left, choose Sensitive Data Identification > Sensitive Data Distribution.
  3. Click the Data Import tab.

    Figure 1 Data Import tab

  4. Click Import Local File. In the displayed dialog box, set required parameters. For details about the parameters, see Table 1.

    Table 1 Parameters for importing local data

    Parameter

    Description

    Data Connection

    Data connection. Currently, only a DLI, DWS or MRS Hive connection is supported (a connection in string mode is not supported).

    Duplicate Data Policy

    Policy for handling the sensitive data that is already in the system. You can select Replace or Skip.

    Select File

    Select a local file to import. Only an .xlsx file no larger than 1 MB is supported.

    Allow partial failure

    If this option is selected, as long as the number of records that fail to be imported does not exceed the threshold you set, the import task is considered successful. Otherwise, the import task fails. If this option is not selected and there are failed records, the import task fails.

    Failures to Ignore

    Threshold for the number of records that fail to be imported. Set this parameter if you have selected Allow partial failure. Enter a value from 10 to 20. If the value exceeds the total number of imported records, the value does not take effect, and default value 0 is used.

  5. Click Import to start the import task.

    The system will check the file to be imported. If no error is found or the number of failed records is less than or equal to the value of Failures to Ignore, the system starts to import data. After the import task is executed successfully, you can go to the Sensitive Data Distribution page to view the import result.

Related Operations

  • Viewing imported data: Click the Sensitive Data Distribution tab to view the sensitive data import result.
  • Viewing the task status: Check the status of an import task in the Status column on the Data Import page.

    The import status can be Importing, Imported, or Import failed. If the task status is Import failed, move the pointer over the question mark to view the failure cause.

  • Viewing task details: On the Data Import page, click the name of a task to view its details.
    • Task details: View the total number of records imported, the number of records that are successfully imported, the number of records that fail to be imported, and the number of records that are overwritten or skipped.
    • Basic information: View basic information about the task.
    • Task configuration: View the configuration of the task.
    • List of failed records: If the task status is Imported but some records fail to be imported, you can view the failed ones and their failure causes.
  • Deleting tasks: On the Data Import page, click Delete in the Operation column to delete a task, or select tasks and click Delete above the list to delete them. When tasks are deleted, the sensitive data that has been imported will not be deleted. Ongoing tasks cannot be deleted.
  • Canceling a task: Click Cancel Import in the Operation column of a task in Importing state to cancel the task.