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 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.
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.
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 (*). |
|
|
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 (*). |
|
|
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 (*). |
|
|
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 (*). |
|
|