'Snowflake defaults searches in public schema even if actual schema doesnot exist
I am using snowflake jdbc, while quering for a table in an invalid schema name, Snowflake still tries to search it in public schema. Is it snowflake's default behavioud? Can I override/change it and throw exception if not found in input schema name ?
eg: I am trying: select * from mydb.test_schema_invalid.table_1; this schema is not present in mydb, but this table is present in public schema, so snowflake is still giving me results for this
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|