Troubleshooting

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Refer to Troubleshoot OCF Connectors.

Refer to the following scenarios for help in troubleshooting common issues.

Problem

The following error message appears in the metadata extraction log while fetching external tables:

Database <database_name> does not exist or is not authorized.

Cause

Lack of neccessary permission to access information schema for external tables.

Solution

Execute the following command for the Snowflake database to provide access to the information schema for external tables:

GRANT USAGE ON DATABASE <database_name> TO <alation_role>;

GRANT USAGE ON ALL SCHEMAS IN DATABASE <database_name> TO ROLE <alation_role>;

GRANT REFERENCES ON ALL EXTERNAL TABLES in DATABASE <database_name> to ROLE <alation_role>;