Snowflake Parameterized Query Isn't Working?

Toa_Lihkan
Toa_Lihkan
in Integrations

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?

Comments

  • gregory_Decisions
    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

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories