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 for metadata extraction
To extract metadata from Microsoft Fabric data lakehouses within a Microsoft Fabric workspace, you need access to the workspace with viewer or higher permissions.
Ensure that you have the following permissions:
•select on sys.all_columns
•select on sys.all_objects
•select on sys.all_parameters
•select on sys.database_principals
•select on sys.databases
•select on sys external_tables
•select on sys.extended_properties
•select on sys.external_data_sources (optional)
Note:
Assign this permission to work with external data sources.
•select on sys.foreign_key_columns
•select on sys.indexes
•select on sys.index_columns
•select on sys.partitions
•select on sys.schemas
•select on sys.sql_modules
•select on sys.synonyms
•select on sys.types
•select on sys.tables
•select on sys.table_types
Permissions to run data profiles
You can run profiles with the permissions required on the source system to perform metadata extraction.
Permissions to run data classification
You can perform data classification with the permissions required on the source system to perform metadata extraction.
Permissions to run glossary association
You can perform glossary association with the permissions required on the source system to perform metadata extraction.