Features

• Increased the performance of Get-ClassificationColumn PowerShell cmdlet, used in all automation, between 6 - 13 times, addressing customer issues when trying to classify a substantial number of columns at once.

Fixes

• Fix for database scan failure, when database objects have extended property with hex values.
• Fix an issue when expanding API category in API page crashes UI.

Features

• Increased the maximum table size in the UI to 500.

Features

• API calls to /hubs/notifications and /hubs/notifications/negotiate are no longer logged - these are automated, internal SignalR calls and just add noise to logs.
• Performance of bulk classification has been improved to make it run significantly faster.

Fixes

• Fixed a bug where it was not possible to set up a non-admin account as the service user.
• API Changes: The Bulk Classification endpoint (api/v1.0/columns/bulk-classification) now accepts an array of ColumnIds instead of the previously more verbose ColumnIdentifiers. PowerShell cmdlets such as Set-Classification has been updated for this change, so it will work in your scripts as before. The Get Classifications endpoint (api/v1.0/instances/INSTANCE_NAME/databases/DATABASE_NAME/columns), exposed via the Get-ClassificationColumn PowerShell cmdlet, returns the appropriate ColumnIds.

Fixes

• Fixed a bug in the configuration app where an exception occurred if the given username was not an administrator.

Features

• Added the ability to remove tags using bulk classification.

Fixes

• The Set-Classification PowerShell script now classifies columns in batches, solving the issues that some users experienced when trying to classify a large amount of columns.
• Classification: Attempting to assign free text attributes to an invalid column (e.g. misspelled database name) now correctly responds with NotFound (404) instead of Ok (200).
• Databases, tables and columns: Requesting details on a missing database (e.g. due to misspelled database name) now correctly responds with NotFound (404) instead of Ok (200).
• Fixed a bug where the Credit Cards and National ID suggestion rules could not be modified.

Features

• Added Start-ClassificationDatabaseScan to the Powershell module.

Fixes

• Disable suggestion operations in the UI when suggestions being regenerated.
• API changes - metadata.status.isReachable (e.g. on api/v1.0/instances/) now returns 'unknown' when no scans have completed on the instance, 'false' when a scan has returned an error, and 'true' when a scan has successfully completed.

Features

• Allow users to configure their own suggestion rules.

Features

• Stopped bulk classification from overwriting tags on all categories.
• API now returns Bad Request or Not Found rather than Internal Server Error when given an invalid free-text attribute, database or instance id in some cases.

Features

• Reduced the number of banners on the column classification page.

Fixes

• Fix CSS bug on taxonomy page for macOS Safari.

Features

• Improve performance of a database scan.
• Added support for SQL Server 2019's Memory-Optmized Tables.

Fixes

• Fix an issue when clicking between two filters too quickly produces an error.
• Fix an issue when SqlDataCatalog is not accessible after upgrade.

Improvements

• Adds Wait-SqlDataCatalogOperation cmdlet to the PowerShell module.

Major changes

• If HTTPS is configured the Config App needs to be rerun in order to make SQL Data Catalog run fine after the upgrade.
• Firefox browser needs to be configured to allow windows authentication.
• If users are accessing SqlDataCatalog from a Mac, specific instructions need to be followed to allow users to use windows authentication.

API changes

• API exposes the status of scanning instances and databases.

Major changes

• The Config App needs to be rerun in order to make SQL Data Catalog run fine after the upgrade. This is due to migration of the API from .NET Framework to .NET Core.
• The encryption mechanism for SQL Server Auth was changed due to the above change. You need to reenter your password if you use SQL Server Auth.

Features

• Improved the UI for bulk classification: to avoid confusion, it is now not possible to modify column selection when the sidebar for classifying multiple columns is displayed.
• Add 'Masking Data Set' sample tag category to facilitate integration with SQL Data Masker.
• Security: tighten CORS configuration.
• Added API documentation to web UI.

Fixes

• Prevent the 'Something went wrong' error when reloading the Taxonomy page with the sidebar open.
• API changes - Hyphenate all API endpoints, i.e. auth-tokens, classification-suggestions, sensitivity-label-distribution.
• API changes - The taxonomy endpoints were renamed - all of them are now prefixed with taxonomy and hyphenated, e.g. /tagcategories was renamed to /taxonomy/tag-categories.