The Discovery Query search options are located at the bottom of the Query panel on the Discovery Search tab.
When you start DataVeil, the defaults are loaded as shown above.
The default is 'All Databases' defined in your project - which is typically one. If you have multiple databases defined in your project then you can click on the 'Scope...' button and select which are searched or ignored.
The combo box allows you to specify Limit or All.
This is the maximum number of rows in a table that DataVeil shall search. The default is 1,000. A range between 1,000 and 10,000 is generally recommended.
This will search all rows of a table. Generally, this is not recommended because it can take a very long time and is usually of limited benefit. This is because the primary objective is to identify columns that are sensitive and this can usually be done with a limited sample. Search processing speed varies depending on your system, network and configured Query; however, you can typically expect between 5,000 and 10,000 rows to be scanned per second.
Search Project Columns
This will select all tables that are defined in your project (shown in the Project explorer tab) for search. This is selected by default.
Search DBMS Columns
This will select all remaining tables on the DBMS (i.e. are not defined in your project under the Project explorer tab and not under the Excluded tab) for search. This is selected by default.
Search Excluded Columns
This will select all tables that you have excluded from your project (shown in the Excluded explorer tab) for search. This is not selected by default because you should only exclude columns that you are certain are not sensitive. Therefore, searching excluded columns would defeat its purpose.
Ignore Columns marked Sensitive
If this option is selected then the search shall ignore all columns already marked Sensitive. This can help you focus on finding only those sensitive columns that are not yet part of your project. The default is not to ignore Sensitive columns.
Ignore Columns marked Not Sensitive
If this option is selected then the search shall ignore all columns that are already marked Not Sensitive. This can help you focus on finding only those sensitive columns that are not yet part of your project without the search result being cluttered by columns that you have already marked as Not Sensitive. The default is not to ignore columns marked as Not Sensitive.
Filter False Positives
If this option is selected then DataVeil shall not report results that it has determined are more likely not matching any pattern configured in the Query, even if a configured pattern appears to match.
For example, if your Query consists of only the Person Last Name system pattern then it would match a column containing names "Black", "Brown", "Silver" and "White" (eg. Mr. Brown can refer to a person.) However, if the 'Filter False Positives' option is selected then Dataveil would determine whether the other rows in this column contain only color names, in which case DataVeil would determine that it is a false positive and therefore not report it as a Person Last Name.
Note: If you are using your own Custom regular expression patterns then you should consider disabling this option because DataVeil may filter out columns that you may have otherwise expected to appear in the search result.
Always Refresh Schema
If this option is selected then DataVeil shall always download a fresh copy of your database schema before it commences a search. The default is not to always refresh schema.
DataVeil will always ensure that the schema has been refreshed at least once since the current project was opened. Therefore, enabling this option would only be meaningful if you think that your schema may have changed since your project has been opened or a subsequent discovery search.