# Resolving SnowflakeException: "Object Does Not Exist or Operation Cannot Be Performed"

**URL:** <https://community.cdata.com/t/resolving-snowflakeexception-object-does-not-exist-or-operation-cannot-be-performed/503>\
**Category:** Data Sources\
**Tags:** article, snowflake, ado.net, entity-framework-core, scafolding\
**Created:** [November 1, 2023, 8:26pm UTC](https://community.cdata.com/t/resolving-snowflakeexception-object-does-not-exist-or-operation-cannot-be-performed/503 "2023-11-01T20:26:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alba\_Trupja](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/alba_trupja/32/991_2.png) [@Alba\_Trupja](https://community.cdata.com/u/Alba_Trupja)\
**Post date:** [November 1, 2023, 8:26pm UTC](https://community.cdata.com/t/resolving-snowflakeexception-object-does-not-exist-or-operation-cannot-be-performed/503/1 "2023-11-01T20:26:46Z")

</div>

If you encounter the System.Data.CData.Snowflake.SnowflakeException with the message “**[500] SQL compilation error: Object does not exist, or operation cannot be performed,**” this article provides guidance on addressing the issue.

This error is typically returned by Snowflake when attempting to access an incorrect Warehouse, Database, or Schema. Snowflake is case-sensitive, and it’s essential to be aware that Databases and Schemes are generated in uppercase letters.

 ![a4e75852-ef7b-4308-9b7b-fe6a7899910e.png](https://us1.discourse-cdn.com/cdata/original/1X/27c0c732939f90b6670cd8b2489a0517d61f6cf8.png)

**Resolution Steps:**

**1. Verify Connection Property in Package Manager Console:**

- Ensure that the connection property in the Package Manager Console is correctly configured, especially when you are scaffolding specific tables.
- Even a blank space in the connection property can trigger this error. Double-check the connection details for accuracy.

**2. Set IgnoreCase=True in the Connection Property:**

- You can set the IgnoreCase=True in the connection property to instruct Snowflake to treat identifiers as case-insensitive.
- The default behaviour is case-sensitive (IgnoreCase=False).
- Example of updated scaffolding command with IgnoreCase=True:

Scaffold-DbContext “url=[https://myaccount.region.snowflakecomputing.com](https://myaccount.region.snowflakecomputing.com);user=Admin;password=test123;Database=Northwind;Warehouse=TestWarehouse;Account=Test;IgnoreCase=True;” CData.EntityFrameworkCore.Snowflake -OutputDir Models -Context SnowflakeContext -Schema PUBLIC -Tables Products

 ![3adc8fe5-aee7-421e-98c6-33a01a70a041.png](https://us1.discourse-cdn.com/cdata/original/2X/9/91766c800614767ec78b56d04dde428b5c56f210.png)

If you continue to face issues after implementing the above steps, don’t hesitate to contact CData support for further assistance and troubleshooting.