Object does not exist or not authorized for SQL compilation regarding the external database connector

0
Hello,    I am trying to connect to Snowflake with the External database connector.   The connection is built successfully, and the query in snowflake is successful as well, so I think the user role has the access to read the database. But I always have one error   "Error: SQL compilation error:Object 'ARTIKEL' does not exist or not authorized. SqlState: 42S02, VendorCode: 2003, QueryId: 01b58d40-0104-23e9-00c4-fd01c577eb0b"   The table exist and the user role has the access to read. Mendix version is 10.12.0, ExternalDatabaseConnector version is 3.0.0 . So I really don't understand what is the reason.   Thanks!  
asked
2 answers
0

Could this be to do with case sensitivity in Snowflake? On the Snowflake side, is the ARTIKEL table all uppercase?

answered
0

Find reasons! In the configuration the schema is not set, so in query the schema must be added. "select * from wawiadm.artikel;"

answered