Forum Discussion

matter's avatar
matter
Regular Visitor
5 years ago

Snowflake Connector - Parameterized Query

Hi there,

 

I'm trying to use the updated Snowflake Connector with support for Value.NativeQuery to execute a simple parameterized query and I'm wondering if its possible or just not supported yet.  (I understand that I can change the actual SQL string and include the parameters, but I'd prefer to use the built-in parameterization for the sake of security and performance on the Snowflake side)

 

As a simplified example, I'd like to update this (which works):

 

Value.NativeQuery(DB, "select * from MATT_DEV.PUBLIC.USERS where ID=1", null, [EnableFolding=true])

 

 

To something like these (that don't work):

 

Value.NativeQuery(DB, "select * from MATT_DEV.PUBLIC.USERS where ID=?", {1}, [EnableFolding=true])

 

 

 Value.NativeQuery(DB, "select * from MATT_DEV.PUBLIC.USERS where ID=:1", {1}, [EnableFolding=true])
Value.NativeQuery(DB, "select * from MATT_DEV.PUBLIC.USERS where ID=@p1", [p1=1], [EnableFolding=true])

 

 

All of these parameterized examples result in the following error:

Expression.Error: Native queries aren't supported by this value.

Details: [Table]

 

I appreciate any help!  Thank you!

Matt

2 Replies

    • matter's avatar
      matter
      Regular Visitor

      amitchandak have you been able to accomplish something similar via other methods?  (like the standard ODBC connector?)