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 Microsoft Fabric Data Warehouse metadata, you need account access and permissions to the Microsoft Fabric Data Warehouse source system. To extract metadata from Microsoft Fabric data warehouses within a Microsoft Fabric workspace, you need access to the workspace with contributor or higher permissions.
Grant permissions that allow you to perform the following operations:
•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.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.tables
•select on sys.extended_properties
•select on sys.external_data_sources
•select on sys.types
•select on sys.table_types
•select on sys.external_tables
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 relationship discovery
You can perform relationship discovery 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.