Feature: Add Purview MSI to Synapse SQL

[marvinbuss]

Feature or Idea - What?

Add Purview MSI automatically to the Synapse SQL Serverless, to simplify the creation of new scans for Synapse workspaces. The steps described here need to be executed: https://docs.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace#authentication-for-enumerating-serverless-sql-database-resources

CREATE LOGIN [PurviewAccountName] FROM EXTERNAL PROVIDER;

Feature or Idea - Why?

This will allow Data Governance personas to more easily create scans for the Synapse workspaces and will allow immediate insights.

[marvinbuss]

This is currently blocked because of the issue described here: https://github.com/MicrosoftDocs/sql-docs/issues/2323

We would have to grant each Synapse workspace DirectoryReader rights. To do that, the Function would require even higher rights. This is not expected to be acceptable for users (escalation of privileges).