Sanitization

Tessell provides the ability to sanitize the databases as an ad-hoc operation or as part of an automated process. You can sanitize the snapshots manually or you can create a schedule to sanitize the snapshots automatically. The sanitized snapshots can be used or shared around for application testing, where full production dataset isn't need to be known. You need a masking SQL script added to your script library to sanitize a snapshot. For more information, see Script Library.

Whenever a snapshot sanitization request is submitted, a workflow is run at backend which creates a clone VM using the source snapshot. After creating a clone VM the masking SQL script is run on the clone VM. Once the script is run successfully and the data is masked, it captures a snapshot from the clone VM and provides a sanitized snapshot.

On the Sanitization tab,

On the top, you can provide the name of your sanitized snapshot in the search bar and search for the particular snapshot and its details.

You can filter the sanitized snapshots according to the status using the Status field next to the search bar. The possible status of the snapshots are:

• All - It is the default option. It displays all the snaphots with any of the possible status.

• Available - Select this option if you want to list all the available snapshots as per the SLA configured for your database service.

• Queued - Select this option if you want to list all the snapshots that are scheduled and are waiting on any other task to get started.

• Creating - Select this option if you want to list all the snapshots that are getting clicked and aren't completed yet.

• Failed - Select this option if you want to list all the snapshots that aren't completed and failed because of any reason.

You can also filter the snapshots based on the data loaded data from the particular script. The possible values are All, and list of the available scripts for your database service.

You can select Clear button to clear the applied filter in search bar, status, and script fields.

By default, it displays list of all the sanitized snapshots and its details:

• Snapshot Name - It provides the name of the snapshot.

• Status - It provides the status of the snapshot. The possible options are Available, Queued, Creating, and Failed.

• Schedule Name - It provides the name of the schedule through which this snapshot was sanitized.

• Size (GiB) - It provides the size of the snapshot in GB.

• Script Name/Version - It provides the script name and version which was used to sanitize the data in the snapshot.

• Availability - It provides the number of regions for which the sanitized snapshot is available. Select the region for particular snapshot to view the details of the region where the snaphsot is available. It provides:

  • Region - The region name for which the snapshot is available.

  • Status - It provides the status of the snapshot if it is available or not as per the SLA.

  • Access Policy - It provides the name of the Access policy defined for your database service.

  • Shared with - It provides the name of the user with whom the snapshot is shared. It says, No users if not shared with the users.

• Snapshot Time - It provides the month, date, year, hours, and minutes exactly when the snapshot was taken.

• TRN — It provides the Tessell resource name. The TRN is a globally unique name. You can copy and use the TRN using the copy button next to its TRN.

Select Show Schedules to see the list of all the schedules and its details for the sanitized snapshots.

• Schedule Name - It provides the name of the schedule created.

• Script info - It provides the name and version of the script which is used to sanitize the snapshot.

• Retention - It provides the number of days for which the sanitized snapshot is to be retained.

• Snapshot Name Prefix - It provides the snapshot prefix name given at the time of creating schedule.

• Create on - It provides the date and time when the snapshot was sanitized.

Create Schedule

Select + Create Schedule to create an schedule through which the snapshots are sanitized automatically at the confifure day and time.

• Schedule Name - Provide the name of the schedule to sanitize the snapshots automatically.

• Description - Optionally provide the description for the schedule you are creating for your future reference.

• Frequency - Select any of the available options:

  • Daily - Select daily if you want to sanitize the snapshots daily.

  • Weekly - Select weekly if you want to sanitize the snapshots weekly. Further select the day/s on which you want this schedule to run.

• Keep each snapshot for - Provide the number of days or weeks you want to retain the sanitized snapshots for.

• Snapshot name prefix - Provide any name to prefix the sanitized snapshots name. By default the prefix name is Sanitized.

• Script - Select the name of the script to be used for sanitizing the snapshots.

• Script version - Select the version of the script from the drop-down list if available.

Select Save to create the schedule. This schedule keeps sanitizing the snapshot at the scheduled day and time.