Skip to content
  • Register

    • Snowflake Parameterized Query Isn't Working?

    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

    • 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

    Quick Links

    Categories