SQL Data Catalog v1.8.x

• Improved the help text in the configuration app.
• The Set-Classification PowerShell cmdlet now has option to update free-text attributes.

Changes

• URLs for pages listing columns have changed: the database name is replaced with the database ID.
• API changes:
  • column/{id}/tags and column/{id}/freetextattributes get and put endpoints have been retired in favour of column/{id} get and patch endpoints.
  • The Powershell module and Web front end have been updated to use the new endpoints; please get in touch with us at if this has broken any of your own code.
  • We have replaced database name in endpoints with database id, and regularised our endpoint structure.
  • Affected endpoints are:
    • instances/{id}/databases has become databases?instanceId={id}
    • instances/{id}/databases/{databaseName} has become databases/{id}/metadata - a smaller return object with just the instance and database id and name is available on databases/{id}
    • instances/{id}/databases/{databaseName}/tables has become tables?databaseId={databaseId}
    • instances/{id}/databases/{databaseName}/columns has become columns?databaseId={databaseId}
    • instances/{id}/databases/{databaseName}/datatypes has become columns/datatypes?databaseId={databaseId}
    • instances/{id}/databases/{databaseName}/columns/export?format={format} has become columns/export?databaseId={databaseId}&format={format}
    • instances/{id}/columns/export?format={format} has become columns/export?instanceId={instanceId}&format={format}
    • instances/{id}/databases/{databaseName} patch endpoint for archiving has become databases/{databaseId}
    • instances/{id}/databases/{databaseName}/scan post endpoint has become databases/scans?databaseId={databaseId}
    • instances/{id}/databases/{databaseName}/scan/{scanId} get endpoint has become databases/scans?databaseScanId={scanId}
    • You can use the databases?instanceId={id} endpoint to get a list of databases with their ids for use with the new endpoints.
    • instances/{id}/sensitivity-label-distribution and instances/{id}/databases/{databaseName}/sensitivity-label-distribution endpoints have been removed - use databases/{id}/metadata to get this data instead