Page History
...
The Aqua Data Studio Data Masking tool makes it convenient to select only the information that you want to be visible to others in your result set while still giving them access to a table's complete result set. This is done so that the data remains structurally workable but does not expose sensitive information.
- Aqua Data Studio has made it easy to enable Data Masking for all the database platforms. By selecting Data Masking under the Tools main application menu or by selecting Tools > Data Masking from the right-click menu in the database Schema Browser.
- It is also accessible from the Query Analyzer Toolbar menu.
For a Google BigQuery connection, the SQL Version - Use Legacy SQL option in the Advanced tab must be unchecked in order for Data Masking to work correctly.
...
The Data Masking workspace has different options. The Enable Data Masking checkbox at the top lets the user enable or disable all data masking rules. The "Enable masked column header indicator" will display an icon in the result header throughout ADS to let the user know that the column that is displayed is also masked.
The toolbar menu in the Data Masking UI gives users different options. Two buttons to select or unselect different columns at once, one to reverse selected columns and one to delete a specific row.
| Note |
|---|
| Note that only one rule can be deleted at a time. |
Configure - To bring up the Data Masking rules dialog.
...
| Info |
|---|
| For MongoDB and Cassandra Databases - Schema column could appear empty. |
Under the Mask Value column, you can select from the dropdown menu if you want it Not Masked, Null, Custom value or leave it Blank. Keep in mind that a blank value only applies to String data types.
| Note |
|---|
| Please note that the Data Masking rules are not automatically updated, and may become invalid if the underlying table or view is altered. In order to avoid this potential issue, please finalize the database table and view designs before configuring data masking rules. |
...
| Note |
|---|
| Note that Data Masking is disabled for an Excel connection in Query Builder. |
