Features

• Reworked the menu system.
• The classifications, suggestions, rules and taxonomy pages now all appear under the new Classify menu.
• The Settings page is now accessed from the icons on the right hand side of the menu.
• The API page is now accessed from the Settings page.
• Shift-click for column sampling query has been changed to ctrl-click
• On the Classification page, ctrl-clicking on a column will now copy a SQL statement to your clipboard. You can then paste that SQL into Microsoft SSMS (SQL Server Management Studio) to inspect the top 100 values of that column.

Fixes

• Fixed an issue where the SQL query generated from the Classification page was not specifying the schema.
• Fixed an issue that made it appear like suggestions page filters support exclusions.
• Fixed columns filter not being applied correctly on suggestions page.
• Fixed an issue where Catalog did not properly register a SQL Server that is part of an Availability Group.

Fixes

• Database snapshots will no longer automatically register as part of the database discovery process.

Features

• Added support for exclusion filters on classification and suggestion rules. For every dropdown filter holding down Shift when selecting a value adds it as an exclusion.
• On the Classification page, shift-clicking on an item in the table will now copy a SQL statement to your clipboard. You can then paste that SQL into Microsoft SQL Server Management Studio (SSMS) to inspect a the top 100 values of that column.
• columns and suggestion-rules APIs now take a different structure for filters.

Features

• Added title to pie chart legends on overview page.
• Added hover-text to explain environment tag icon on instance cards.
• Added onboarding checklist feature to help new users get started.
• Onboarding checklist items are checked off automatically when each action is performed, to show new users their progress.

Fixes

• Fixed a potential UI lock-up when generating suggestions on fast databases.

Features

• Added a new default suggestion rule for classifying Countries (will only apply to new installs of Data Catalog).
• Further tweaks to existing suggestion rules to improve accuracy.

Features

• Added additional default rules for new installations of SQL Data Catalog helping to classify Gender, Occupation, Middle Name, Title and Location.

Features

• Made some tweaks to the default rules to reduce noise and help you classify quicker.

Fixed

• Makes datetime formatting consistent in the 'Pruning operation history' description.

Features

• The suggestions count bubble now updates following a suggestion scan, archiving a database and deleting an instance.

Fixed

• Fixed issue where the count of not classified columns could be negative on the database card.

Features

• Improved user experience of the Instances and Databases pages.

Fixed

• Fixed a bug in the calculation of row counts on SQL Server 2019.

Features

• SQL Data Catalog now ships with two default descoping rules to help you classify your estate faster.

Features

• Now shows the amount of columns that have classification suggestions in donut charts on the instance and database pages.

Features

• You can now navigate directly to the suggestions for any given instance by clicking on the link in the relevant instance card.

Features

• Data Catalog now shows the number of suggestions in a blue pill label in the menu bar.
• Snapshots can now be viewed in the background operations sidebar.
• Added a background runner that cleans up all completed or failed operations older than 180 days.

Features

• Checked rows are now highlighted on Suggestions and Classification pages.
• Improved styling of the background operations sidebar and help menu.

Fixes

• Fixed rendering issue with table view display.
• Fixed an error where the estate-wide suggestions page was not rendered.

Features

• Database scans can now be viewed in the background tasks.
• Get-ClassificationColumn cmdlet now supports Predicted Information Type Filter.

Features

• Added a new help menu. Just click the "?" icon in the main menu.

Features

• Improvements
  • Added the ability to export filtered results on the Classification page.
  • Improved usability of Suggestions page.
  • Suggestions are now centrally accessible through the main Suggestions tab.
• API changes
  • The /columns/dataexport endpoint now accepts filter criteria on the query string, e.g. databaseNames=AdventureWorks2019&columnNameSubstring=%Name% (like the /columns endpoint but does not support the take and skip options).

Features

• Improvements
  • Instance scans are can now be viewed in the background tasks.
  • Added the ability to filter suggestions by rule, instance, database, table and column.
• API changes
  • The /instances/<instance id>/scan/<instance scan id> has been removed. The /instances/<instance id>/scan endpoint will now return a link to the operations endpoint /operations/<operation id>.
  • The /instances, /instances/<instance id> and /instances/metadata/<instance id> endpoints no longer return the status and error messages from the scans. To find the status of the last scan use the /operations endpoint.

Fixes

• Fixed an issue where the product would indicate there were more suggestion rules than actually exist when reporting suggestion generation progress.

Features

• Major changes
  • You can now review and apply suggestions across your entire estate.
• Improvements
  • Ensures instances and databases are displayed alphabetically on the overview pages.
  • Displays progress for the Data Scanning and Suggestion Generation background tasks.

Fixes

• Increased the number of background operations that can be queued.