Forum Discussion

azvineth's avatar
azvineth
New Contributor
3 years ago

Parameterizing Snowflake query in Snaplogic

I am trying to execute a Snowflake query to fetch some columns data in a table using Snowflake Execute snap. Select “id”, “user_name”, “user_location”, “user_email” from t_user where “user_location...
Supratim's avatar
Supratim
Contributor III
3 years ago

@azvineth Can also try the below option -

"Select id, user_name, user_location, user_email from t_user where user_location = ‘%s’ order by id ".sprintf(_u_loc)

  • azvineth's avatar
    azvineth
    New Contributor
    3 years ago

    @Supratim Nope. Throws the below error.
    Failed to execute query: Select id, user_name, user_location, user_email from t_user where user_location = ‘Chennai’ order by id
    Reason:
    SQL compilation error: error line 1 at position 7 invalid identifier ‘ID’