Fixes

• Fixed regression related to the number of suggestions available presented in the instance summary view.
• Fixed regression where reloading a page doesn't work.
• Fixed empty audit shapshot when the instance name starts with .\
• API changes - Removed unused properties from the metadata details of instance and database.

Features

• UI: Enforce single-line tag values.

Features

• It is now possible to easily open the configuration app again after the initial setup finishes.
• Improved the performance of bulk classification.

Features

• The API now returns security-related HTTP response headers.
• The built-in Microsoft tags now have descriptions.

Features

• SSL can now be configured using the Configuration app.
• The API now returns the Content-Security-Policy HTTP header.
• Audit events are now generated when authorization tokens are created and deleted.

Features

• Enhanced the security of the Web UI.

Features

• Tag categories are now displayed in the same order throughout the Data Catalog UI.

Fixes

• Fixed a bug in the web client that meant changes to a column's freetext attributes might not be immediately reflected in the UI.
• Fixed a bug where it appeared that suggestions were not applied.
• API changes
  • Rename /audit/classification to /audit/export.
  • Rename instances/{InstanceId}/databases/{DatabaseName}/columns/all to instances/{InstanceId}/databases/{DatabaseName}/columns/export.

Features

• Removes domain name column from the Permissions grid.

Fixes

• Ignore extended properties with NULL values during scans.

Fixes

• Don't reset permissions if a user from a different domain is added.
• Allow adding users with the same name but from different domains.
• Do not cache an empty domain list if Active Directory server is down.
• Ensure that the domain provided is taken into account in all scenarios when permissions are granted.
• Display a message if the user is unauthorized for access Sql Data Catalog.

Due to major changes in the permissions handling it is recommend that you disable permissions before applying this update.

Features

• Add support for cataloging mirrored databases.
• Include audit entries of taxonomy changes and requests of an instance scan in the UI.
• Display the role holder when deleting a user or group on the permissions tab.
• API changes
  • Export all types of events in a CSV file from the audit log (incl. taxonomy changes and instance scan requests).

Fixes

• Align the plus and the text "Add Instance" on the Catalog page.

Features

• Changes to the taxonomy are now audited.
• Requesting an instance scan is now audited.
• The Update-ClassificationInLiveDatabase PowerShell cmdlet now uses the ADD SENSITIVITY CLASSIFICATION syntax when targeting SQL 2019 or Azure SQL.
• Handle the UPN form of a user name when adding users for permissions.
• API changes
  • The columnClassificationAuditEntries field returned from the /audit endpoint has been renamed to auditEntries.
  • The /audit API endpoint takes some new eventFilter values to control which audit data should be returned. For example, setting eventFilter=TaxonomyChanged will return all modifications made to the taxonomy. See the Swagger documentation (at /swagger) for the /audit endpoint for the full list of filters.

Features

• Improves error handling in PowerShell module when invalid tag is provided.
• SQL Data Catalog now reads sensitivity classifications from the sys.sensitivity_classifications table in SQL 2019 and Azure SQL, when the database is first added to the catalog.
• Added warning messages about SSL configuration when adding an instance with SQL Server authentication and when configuring SQL Data Catalog.
• Extend default taxonomy by adding a "System" tag to the "Sensitivity" built-in category.

Fixes

• Improves handling of canceled requests.

Features

• Permissions list is purged as a result of improving performance on loading permissions list.
• Improved performance on loading permissions list.
• API changes
  • Added endpoint DELETE api/v1.0/permissions/domains/{domain}/users/{userSID} for deleting users.
  • PUT api/v1.0/permissions is no longer responsible for deleting users from permissions list.

Fixes

• Support empty collection of columns provided to Set-Classification.

Fixes

• Weekly snapshots are now taken as intended (every Sunday).

Features

• Breaking change of PowerShell cmdlets - most of the cmdlets were renamed, parameters and return types of some of them were changed. The full list of breaking changes:
  • Use-Classification becomes Connect-SqlDataCatalog
  • Enable-Authorization becomes Enable-SqlDataCatalogAuthorization
  • Add-RegisteredSqlServerInstance becomes Register-ClassificationInstance (-Force param removed)
  • Update-RegisteredSqlServerInstance becomes Set-ClassificationInstanceCredential
  • Start-InstanceScan becomes Start-ClassificationInstanceScan
  • Get-RegisteredInstances becomes Get-ClassificationInstance (return type changed)
  • Get-Databases becomes Get-ClassificationDatabase
  • Get-Columns becomes Get-ClassificationColumn
  • Copy-DatabaseClassification becomes Copy-Classification
  • Export-ClassificationCsv becomes Export-Classification (new -Format param (csv, zip))
  • Export-ClassificationExtendedProperties becomes Update-ClassificationInLiveDatabase
  • Get-TagCategories becomes Get-ClassificationTaxonomy
  • Update-ColumnTags (forceUpdate=off) becomes Add-ClassificationColumnTag
  • Update-ColumnTags (forceUpdate=on) becomes Set-ClassificationColumnTag
  • Import-ColumnsTags (override) becomes Set-Classification
• The 'Auth Tokens' page was improved, the generated auth-token is now fully visible in all browsers.
• Improved Do not clear the values provided when adding permissions fails.
• Moved auth token and permissions navigation menu items from the top bar into Settings.