Error: Unable to Access Existing Tables

Issue

Syncs fail with the following error:

Error: Unable to access existing tables

A re-sync resolves the error temporarily, but it appears again during incremental syncs.

Environment

Destination: Snowflake

Resolution

To resolve this issue, grant the required privileges to the Fivetran user:

GRANT CREATE SCHEMA, MONITOR, USAGE ON DATABASE <database_name> TO ROLE <role_name>;

After updating the privileges in the destination, re-sync your connection. To learn how, see How to Trigger Re-Syncs for Fivetran Connections.

To review the full Snowflake permissions script and confirm that the destination user has all required privileges, see our Snowflake Destination Setup Guide.

Cause

This issue occurs when the Fivetran user is missing one or more required privileges on the Snowflake destination database:

• CREATE SCHEMA: Allows the user to create schemas in the database.
• MONITOR: Allows the user to view database properties and run monitoring operations.
• USAGE: Allows the user to access and use the database.

For more information, see the Snowflake documentation on database privileges.