Permissions for metadata extraction
Ensure that you have the required permissions to enable metadata extraction.
Verify that you have the following permissions:
- •READ and EXECUTE permissions on folders to access and traverse the folders
- •READ permission on files
- •SELECT permissions on system tables for the Snowflake database user account:
- - select on information_schema.EXTERNAL_TABLES
- - select on information_schema.FUNCTIONS
- - select on information_schema.PIPES
- - select on information_schema.PROCEDURES
- - select on information_schema.SCHEMATA
- - select on information_schema.SEQUENCES
- - select on information_schema.STAGES
- - select on SNOWFLAKE.ACCOUNT_USAGE.TAGS
- - select on SNOWFLAKE.ACCOUNT_USAGE.TAG_REFERENCES
- •SHOW permissions on database objects for the Snowflake database user account:
- - show columns
- - show primary keys
- - show imported keys
- - show streams
- - show materialized views
- - show tasks
- - show databases
- - show objects