title: snowflake XML Parsing returns NULL - SPACE in field name?
body: <p>I am trying to get the ap id value in below xml but getting NULL back. Please help. If possible please send me a flatten query to flatten the below xml file in snowflake. I am very new to snowflake and any of your help will be much appreciated. Is this because of the space in the field name "ap id"? I doubt that. How to process the field names with space in snowflake for XML files?</p>
  
  <p>select GET(lvl,'@ap id')::integer as "ap id" from
  (SELECT src:"$" as lvl FROM XMLDATA);</p>
  
  <p>SELECT XMLGET(SRC, 'ap id' ):"@" as "ap id"
  FROM XMLDATA;</p>
  
  <p>SELECT
       GET(src, '@ap id')::integer as ap_id
  FROM XMLDATA;</p>