Error running query in Talend

[Anonymous]

I'm having a problem running an update query in Talend.  I get the error that is attached.  I can run the following query just fine in Snowflake without an issue.  I works ok in Snowflake, but not in Talend.  I have used other update statements in Talend with snowflake.  

update "EMS"."PUBLIC"."PGA_CLEAN_SUBSCRIBED"
SET rydercup_2020 =
replace (rydercup_2020,'"','')
where email_address <> ''

[akumar2301]

You have to convert it in java string.

I suggest to create this update query as java string variable and print. You will see the issue.

E.g Your query should start with “ .
If in your query you have “ and it is mandatory it should be escaped like \”EMS

[Anonymous]

This is what I am running in Talend.

"update "EMS"."PUBLIC"."PGA_CLEAN_SUBSCRIBED"
SET rydercup_2020 =
replace (rydercup_2020,'"','')
where email_address <> ''"

I do have double quotes at the end and the beginning. As I said earlier I
can run the same query without the double quotes in Snowflake, but I then
when I try to run it in Talend I get the error message that I attached
earlier.

[DataTeam1]

@gfred try this

"update EMS.PUBLIC.PGA_CLEAN_SUBSCRIBED
SET rydercup_2020 =
replace (rydercup_2020,'" + "\"" + "','')
where email_address <> ''"

Notice that 

" - is red coloured

' - is blue coloured