
Answer-first summary for fast verification
Answer: CHECK_XML
The CHECK_XML function in Snowflake is specifically designed to validate XML documents. According to the community discussion and Snowflake documentation, CHECK_XML checks the validity of an XML document - if the input is NULL or valid XML, it returns NULL (no error), and if there's an XML parsing error, it returns an error message. This directly addresses the question about validating XML objects. The other options are not suitable: XMLGET is for extracting data from XML, TO_XML converts data to XML format, and PARSE_XML parses XML but doesn't specifically validate it like CHECK_XML does.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.