Snowflake Parameterized Query Isn't Working?

Toa_Lihkan

Greetings,

I've integrated with the Snowflake DB and was seeing relative success in building parameterized queries to the DB. However, now that I'm trying to pass in variables, I seem to be running into some issues. For example, I have a query that reads:

SELECT * FROM mytable

WHERE item = @itemname

Running this gives me a 42000 error. Any ideas as to how to get my query running?

gregory_Decisions

Hello there!

If you are connecting to a Snowflake DB, you will probably need a to alter your query to:

SELECT * FROM mytable

WHERE "item" = ?

Be sure to exclude the '?' from the parameter section. We hope this helps!

-Gregory