Error: Insufficient Privileges to Operate on Database

Issue

While setting up and testing the destination, the following error appears:

SQL access control error: Insufficient privileges to operate on database

Environment

Destination: Snowflake

Resolution

To resolve this issue, do the following:

1. Grant the required privileges to the Fivetran role, replacing <database_name> and <Fivetran_role> with the appropriate values:

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

2. In Fivetran, go to your Snowflake destination page.
3. In the top right, click the more options menu, then click Edit connection details.
4. Click Save & Test.

For more information, see the our Snowflake Destination Setup Guide.

Cause

This issue occurs when the Fivetran role lacks the privileges required to perform validation operations, such as creating a temporary schema or verifying internal stage access.