https://docs.snowflake.com/en/sql-reference/functions/check_xml
PREVIEW FEATURE
— OPEN
Enabled for all accounts.
Checks the validity of an XML document. If the input string is NULL or a valid XML document, the output is NULL. In case of an XML parsing error, the output string contains the error message.
Also see this one, it has a similar purpose, but it's for JSON: https://docs.snowflake.com/en/sql-reference/functions/check_json. Checks the validity of a JSON document. If the input string is a valid JSON document or a NULL, the output is NULL (i.e. no error). If the input cannot be translated to a valid JSON value, the output string contains the error message.
D.
The CHECK_XML
() function in Snowflake can be used to check the validity of an XML document. The expression STR => string_containing_xml should evaluate to a VARCHAR
that contains valid XML.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0e504b5
8 months, 3 weeks ago0e504b5
8 months, 3 weeks agoGwo
9 months ago