The Workspace Settings page displays five configuration items: Partition Date Format, Partition Field Name, Temporary Table Prefix, Upload Table (Import Table) Prefix, and Mask Data in Page Query Results.

Click Setup in the lower-left corner of the DataStudio page to go to the Setup page.

In the top navigation bar, click Workspace Settings to configure a workspace.

Parameter Description
Partition Date Format The default date format of partition field values. You can modify the format as required.
Partition Field Name The default name of a partition field.
Temporary Table Prefix The prefix of temporary table names. By default, tables with the prefix t_ in their names are identified as temporary tables.
Upload Table (Import Table) Prefix The prefix of the names of tables uploaded on the DataStudio page.
Mask Data in Page Query Results When the switch is turned on, the result returned for an ad hoc query node in the current workspace will be masked.

Enable data masking for DataWorks workspaces

Data masking needs to be enabled for DataWorks workspaces one by one. After data masking is enabled, the result returned for an ad hoc query node in the current workspace will be masked. The underlying storage data is not affected because only dynamic masking is performed.

Note For example, data masking is enabled in workspace A but not workspace B. If you initiate a request in workspace B to query tables in workspace A, the query result is displayed in plaintext.

Click the Workspace Settings tab and turn on Mask Data in Page Query Results. After you click Save, the result returned for a temporary query task in the current workspace will be masked.

Note By default, the Mask Data in Page Query Results switch is turned off and you are not allowed to download masked data.
After data masking is enabled for DataWorks workspaces, the data types listed in the following table are masked by default.
Type Data masking rule Raw data Masked data
ID card number Only the first and last digits in a 15-digit or an 18-digit ID card number are displayed in plaintext. All the other digits are displayed as asterisks (*). 512345678943215678 5*************8
Mobile number Only the first three and last two digits in a mobile number in mainland China are displayed in plaintext. All the other digits are displayed as asterisks (*). 18112345678 181******78
Email address If the string before the at sign (@) in an email address contains three or more characters, only the leftmost three characters are displayed in plaintext, followed by three asterisks (*). If the string before the at sign (@) contains only one or two characters, the entire string is displayed in plaintext, followed by three asterisks (*).
  • eftry.abc@gmail.com
  • af@abc.com
  • eft***@gmail.com
  • af***@abc.com
Bank card number Only the last four digits in a credit card number or deposit card number are displayed in plaintext. All the other digits are displayed as asterisks (*).
  • 1234576834509782
  • 643257829145430986
  • ************9782
  • ***************0986
IP address or MAC address Only the first segment in an IP address or a MAC address is displayed in plaintext. All the other characters are displayed as asterisks (*).
  • 192.000.0.0
  • ab:cd:11:a3:a0:50
  • 192.***. *. *
  • ab:**:**:**:**:**
License plate number Only the one-character provincial abbreviation and the last three characters in a license plate number are displayed in plaintext. All the other characters are displayed as asterisks (*).
  • (One-character provincial abbreviation)AP555B
  • (One-character provincial abbreviation)ADP555T
  • (One-character provincial abbreviation)A**55B
  • (One-character provincial abbreviation)A***55T
Note If you want to mask more data types or have special requirements on the masked data formats, complete your masking settings in Data Security Guard. The feature of masking data for DataWorks workspaces must work with Data Security Guard. For more information, see Enter Data Security Guard.