Error: Object Does Not Exist, or Operation Cannot Be Performed

Issue

The connection fails. The following error appears:

SQL compilation error: Object does not exist, or operation cannot be performed.

Environment

Connector: Snowflake

Resolution

To resolve this issue, do the following:

1. Check that you have completed the setup form correctly.

   i. In Fivetran, go to your Snowflake connection page.

   ii. Select the Setup tab.

   iii. Click Edit connection.

   iv. Ensure the Username, Database Name, and Role fields are filled in correctly using upper-case letters.

   v. Click Save & Test.

2. In Snowflake, ensure the authorizing user has the following privileges on the database:

   • CREATE SCHEMA
   • MONITOR
   • USAGE
   • OWNERSHIP

Cause

This issue occurs when you provide incorrect or invalid information in the connector setup form or the authorizing user lacks required privileges.