Fixes

• Fixed an issue when starting Data Catalog with a large number of background tasks queued.

Features

• Added the ability to run data scanning on a separate thread to other background operations.

Features

• Data scanning will not re-scan a column, even if no prediction was previously found.
• Suggestions are only hidden when a suggestion scan is running for that database, not when there is a suggestion scan waiting in the queue.

Features

• Suggestion Generation now occurs per-database.

Features

• Added Microsoft PowerShell module cmdlets for getting operation data.
• Moved the regeneration of suggestions to a background operation.
• Moved data scanning to a background operation.
• Data Scanning now uses the TABLESAMPLE on large database tables to increase performance by reducing the number of table scans.
• Removed the /suggestions/scans/{id} endpoint, posting to the /suggestions/scans endpoint will return a link to the background operation /operations/{operation id}.

Fixes

• Fixed an issue where databases part of an availability group without a listener weren't picked up.

Features

• Added a new sidebar that shows the status of background operations in SQL Data Catalog. Currently, only the deletion of instances are supported.

Features

• Deleting instance progress is now observable through new Operations API.
• Created the /operations endpoint to track the progress of background operations.
• The DELETE method /instances/ will now return the URL of the associated operation in the Location header.

Fixes

• Fixed an error when downloading a CSV of the audit trail.

Features

• You can now customize the port and virtual path that SQL Data Catalog runs under.
• The /operations endpoint for tracking the the progress of taking a snapshot has been moved to /snapshotoperations.

Fixes

• Fixed an error when downloading a CSV of the audit trail.

Features

• Increased timeout for Get-ClassificationDatabase cmdlet.
• Data scanning is now enabled by default when adding a new instance.

Features

• Redgate now asks for feedback when data scanning is disabled for an instance that had it enabled previously.

Features

• Added the ability to reject predictions from SQL Data Catalog's data scanning feature.

Features

• Improved performance for Get-ClassificationDatabase Microsoft PowerShell function.

Features

• Added a Phone number classifier to the data scanning capability. Currently this supports US and UK phone numbers.
• Improved the family name classifier.
• Suggestions page now displays the predicted information type.
• Default suggestion rules now use predicted information type if available when generating suggestions.
• Suggestions endpoint response now includes predicted information type for each column.

Features

• Added a number of classifiers, improving the data scanning capability:
  • US States.
  • US ZIP codes.
  • UK postal codes.
  • US Social Security numbers.
  • UK National Insurance numbers.
    • To fire off a new data scan, click the Scan for new databases link on your instance card or the Scan for updated schema link on your database cards.

Fixes

• Fixed an issue with the generation of duplicate predictions.

Features

• Added the ability to restrict table filter, in the filter bar, by selected instances and databases.
• Calling the DELETE method on /instances/{instanceid} is now asynchronous. Calls will now receive a 202 Accepted response instead of a 204 No Content.

Fixes

• Fixed an error handling bug inside the PowerShell module.
• Fixed an issue in Data Scanning with TEXT and NTEXT columns
• Fixed a timeout issue when deleting instances.

Features

• Added a new data scanning feature:
  • Sample your data to help identify sensitive columns quicker.
  • Can be enabled on a per instance basis.
• Data responsible for rendering various dashboards is now cached for up to 1 minute to increase overall responsiveness.
• Improved reliability of suggestion generation by increasing timeout.
• The 'v1/columns' endpoint now also returns a "Predicted Information Type" value.