Snowflake Query Issue

Ignition
1

I setup a JDBC Drive, a custom translator and a database connection to snowflake according to the insrtuctions. https://support.inductiveautomation.com/hc/en-us/articles/4408715117197-Creating-database-connections-with-custom-translators-and-3rd-party-JDBC-drivers.

When I go in designer and open the database query browser I can see the connection and the tables in the database, but when I try to do a basic Select query, I get an error.

Query
SELECT * FROM v_product

Error Popup
Message
Error running query: SELECT * FROM v_product SQL compilation error: Object 'V_PRODUCT' does not exist or not authorized.
Details
GatewayException: SQL compilation error:
Object 'V_PRODUCT' does not exist or not authorized.
caused by SnowflakeSQLException: SQL compilation error:
Object 'V_PRODUCT' does not exist or not authorized.

Ignition v8.1.31 (b2023081007)
Java: Azul Systems, Inc. 11.0.18

2

That error is coming from the Snowflake JDBC driver, not from Ignition itself. You should look for this problem in Snowflake.

3

Thanks pturmel. I logged on snowflake and could see my queries vs other queriess and found that i need to have the format SELECT * FROM "my_database"."my_schema"."my_table"