azvineth
New Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Parameterizing Snowflake query in Snaplogic
@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’3.5KViews0likes0CommentsRe: Parameterizing Snowflake query in Snaplogic
@bojanvelevski That did not work. Got 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’ SQL compilation error: syntax error line 1 at position 8 unexpected ‘‘id’’3.5KViews0likes0CommentsParameterizing 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” = ‘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”;”4.4KViews0likes5Comments