英文:
Microsoft Purview is not able to scan serverless table's fields
问题
在扫描 Microsoft Purview 的 Synapse 无服务器 SQL 表时，无法达到列级别的详细信息。
尝试找出为什么无法扫描表列的原因。
对于这个问题的任何线索都将不胜感激。
请查看扫描和结果的屏幕截图。扫描结果为 Synapse Workspace > Serverless SQL 数据库 > 架构 > 表
英文:
While scanning Synapse Serverless SQL tables from Microsoft Purview, not able to reach till column-level details.
Trying to figure out what could be the reason for not scanning the table columns.
Any leads for this issue would be appreciable.
Please find below the screenshot of the scan and the result. Scan gives the
Synapse Workspace > Serverless SL Database > Schema > Table
答案1
得分: 2
扫描无服务器数据库表以查看账户。
将Reader角色添加到Purview账户以与synapse工作空间同步。
使用以下代码为purview账户在无服务器数据库中创建登录：
CREATE USER [<PurvieName>] FOR LOGIN [purview];
ALTER ROLE db_datareader ADD MEMBER [<PurvieName>];
在根据您的要求扫描无服务器数据库时添加权限。更多信息，请参考以下链接：
- https://learn.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace?tabs=MI
- https://www.serverlesssql.com/integrating-azure-purview-with-synapse-analytics-serverless-sql-pools/.
英文:
To scan serverless database table to purview account.
Add Reader role to the Purview account to the synapse work space.
Create login for purview account in serverless database using below code:
CREATE USER [<PurvieName>] FOR LOGIN [purview];
ALTER ROLE db_datareader ADD MEMBER [<PurvieName>];
Add permissions to the serverless databases to scan according to your requirement. For more information you can refer below:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论