Skip to main content

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

  • 19 October 2023
  • 0 replies
  • 1178 views

 

 

 

This error occurs when setting up a connection using any of our Snowflake Drivers. This error happens due to an incorrect value set in Warehouse, Database or Schema.  

Additionally, Snowflake is case-sensitive and usually, Databases and Schemas are generated in upper-case letters, so it would help to follow the same convention when completing these connection properties.  

Alternative Solution: You can set the IgnoreCase connection property to True. IgnoreCase is a session parameter that specifies whether Snowflake will treat identifiers as case sensitive.  

The default value is false (meaning case is sensitive).