Profile a table in test mode

If you want to test the discovery service, you can profile a table in test mode. Test mode lets you configure profiling for a single table. For information about the supported tables, see Supported resources.

Pricing

For tables that are less than or equal to 1 TB in size, you can run test mode at no charge up to 25 times for each project. Related charges for using connected services still apply. A regeneration of a profile counts as one run.

For tables that are larger than 1 TB, you are charged based on your chosen discovery pricing mode.

For full pricing information, see Single-table testing pricing.

Differences between profiling in test mode and standard profiling

Test mode differs from standard profiling in the following ways:

  • Test mode is available only in project view.
  • A table-level scan configuration (that is, a scan configuration for test mode) lets you profile only one table.
  • You can create many table-level scan configurations for different tables in a project. For each table, you can have only one table-level scan configuration.
  • To prevent unintended consumption of test-mode runs, reprofiling is disabled by default for test-mode configurations. That is, a data profile that was generated in test mode isn't reprofiled automatically when the underlying table undergoes a schema change. You can change these settings by editing the profiling frequency in your scan configuration.

Create a test-mode configuration

To create a test-mode configuration, follow the instructions for creating a project-level scan configuration. When you're prompted to select a resource to scan, select Scan one table, and enter the details of the table.

Profile regeneration

Sensitive Data Protection reprofiles tables as described in Frequency of data profile generation. You can customize the profiling frequency in your scan configuration by creating a schedule. To force the discovery service to reprofile your data, see Force a reprofile operation.