To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions to extract metadata
Ensure that you have the required permissions to enable metadata extraction.
Configure the VIEW DEFINITION and CONNECT permission for the user account to view all schemas from where you can load metadata.
For information about configuring permissions for the user account, see the Microsoft Azure Synapse documentation.
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
Grant the db_owner privilege or the following more granular privileges to the user to connect to Microsoft Azure Synapse Data Warehouse:
•EXEC sp_addrolemember 'db_datareader', '<user>'; // Alternately assign permission to the individual table.
•EXEC sp_addrolemember 'db_datawriter', '<user>'; // Alternately assign permission to the individual table.
•GRANT ALTER ANY EXTERNAL DATA SOURCE TO <user>;
•GRANT ALTER ANY EXTERNAL FILE FORMAT TO <user>;
•GRANT CONTROL TO <user>; // To grant all permissions on the database.
Note:
You need this permission to create and access the external data source. The Microsoft Azure Synapse SQL connector uses the Polybase command to load data from external data sources. Polybase requires external tables to reference external data.
or
GRANT ALTER ON SCHEMA::<schema_name> TO <user>; // To grant permissions only on the specified schema.
Note:
Verify that you configured the External Data Source property in the advanced connection properties for Microsoft Azure Synapse SQL Connector.
•GRANT CREATE TABLE TO <user>;
Permissions to perform data classification
You can perform data classification with the permissions required on the source system to perform metadata extraction.
Permissions to perform relationship discovery
You can perform relationship discovery with the permissions required on the source system to perform metadata extraction.
Permissions to perform glossary association
You can perform glossary association with the permissions required on the source system to perform metadata extraction.