# Snowflake Query Issue

**URL:** <https://forum.inductiveautomation.com/t/snowflake-query-issue/90719>\
**Category:** Ignition\
**Created:** [May 22, 2024, 4:46am UTC](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719 "2024-05-22T04:46:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Collin\_Hodges](https://avatars.discourse-cdn.com/v4/letter/c/f9ae1b/32.png) [@Collin\_Hodges](https://forum.inductiveautomation.com/u/Collin_Hodges)\
**Post date:** [May 22, 2024, 4:46am UTC](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719/1 "2024-05-22T04:46:49Z")

</div>

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](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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 22, 2024, 11:52am UTC](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719/2 "2024-05-22T11:52:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Collin\_Hodges](https://avatars.discourse-cdn.com/v4/letter/c/f9ae1b/32.png) [@Collin\_Hodges](https://forum.inductiveautomation.com/u/Collin_Hodges)\
**Post date:** [May 25, 2024, 12:57pm UTC](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719/3 "2024-05-25T12:57:16Z")

</div>

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"