Snowflake Parameterized Query Isn't Working?
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
Howdy, Stranger!
Categories
- 2.1K All Categories
- 17 General
- 154 Installation / Setup
- 988 Flows
- 86 Rules
- 199 Administration
- 203 Portal
- 429 General Q & A
- 596 Forms
- 282 Reports
- 3 Designer Extensions
- 38 Example Flows
- 32 CSS Examples
- 1 Diagram Tile
- 5 Javascript Controls
- 137 Pages
- 1 Process Mining
- New Features
- 147 Datastructures
- 49 Repository
- 165 Integrations
- 25 Multi-Tenant
- 21 SDK
- 39 Modules
- 36 Settings
- 19 Active Directory
- 12 Version 7
- 34 Version 8