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” = ‘Chennai’ order by “id”;
Now in the above query I need to parameterize the filter used and so I introduced a pipeline paramter “u_loc” in the pipeline properties and changed the query as below. But it shows query parsing failed error on validation.
“Select “id”, “user_name”, “user_location”, “user_email” from t_user where “user_location” = '”+_u_loc+“’ order by “id”;”
