Escape double quote Character in Kognitio

Question

It seems that the Kognito console use this template for password reset (also create user)

ALTER USER user_name ALTER PASSWORD TO " "; -- we cannot include a " character in the password which would end up in syntax error.

How do we escape this and include a " character

Answer 1

Finally found one solution from the manual

ALTER USER user_name ALTER PASSWORD TO 'Pass"word' ESCAPE '"';