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...
Forum Discussion
Hi @azvineth,
Try the following:
"Select 'id', 'user_name', 'user_location', 'user_email' from t_user where 'user_location' = '"+_u_loc+"' order by 'id';"
If you place a mapper in front of the Snowflake Execute snap, you’ll be able to validate the query and see how it looks before sending it to Snowflake. Just for debugging purposes.
Regards
Bojan
