Synapse and Purview

rm -r dp-203 -f

git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203

 cd dp-203/Allfiles/labs/22

./setup.ps1

 

 

 

 

 

CREATE LOGIN purviewxxxxxxx FROM EXTERNAL PROVIDER;
GO

CREATE USER purviewxxxxxxx FOR LOGIN purviewxxxxxxx;
GO

ALTER ROLE db_datareader ADD MEMBER purviewxxxxxxx;
GO

 

CREATE USER purviewxxxxxxx FROM EXTERNAL PROVIDER;
GO

EXEC sp_addrolemember 'db_datareader', purviewxxxxxxx;
GO

 

 

 之前报错，有一个权限AIM的没有赋值，synapse的

 

 Discover and govern Azure Data Lake Storage (ADLS) Gen2 | Microsoft Learn

 

 

 

 

 

Troubleshoot scans and connections in the Microsoft Purview Data Map | Microsoft Learn